Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “casuists” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
casuists103652(None) 
casuist9411301casuist_
assists738472_assists
bassists1037182bassists
cambists1437022cambists
cassises103811742cassises
casuistic1344942casuistic
casuistry1442002casuistry
catsuits1045432catsui_ts
classists11296242classists
coassists11275762coassists
cosmists1237992cosmists
fascists1336612fascists
acquests1944643acquests
acquits1857293acqui_ts
ageists848493_ageists
agists75713173_a_gists
aorists74215833_aorists
artists74215593_artists
aspises9611643_aspises
assist6314603_assist_
aurists74615783_aurists
autists73814853_autists
baptists1236723baptists
bassist9312743bassist_
cabalists1339153cabalists
caddises12329353caddises
cajuputs1941793cajuputs
calumets1236283calumets
cambisms1645803cambisms
cambist13312113cambist_
camisas113411923ca_misas
camises114218463ca_mises
canoeists1147163canoeists
canonists1158513canonists
caseases10410473caseases
caseins93115053casei_ns
caseoses1039293caseoses
cashiers13318883cashiers
casings104013513cas_ings
casinos93512833cas_inos
casita82913703cas_i_ta
casitas93312043cas_itas
caskets133910173cas_kets
cassias93514343cassi_as
cassinas103610633cassinas
cassines103116613cassines
cassinos10309353cassinos
cassis84818853cas__sis
casteisms1345253casteisms
castings113614053castings
casts77237793ca___sts
casuals91410523casu_als
casualty1344473casualty
casuistries1352743casuistries
casus76419253casu___s
catmints1236663catmints
catsuit959393catsui_t_
causes88026473ca_u_ses
cayuses12188403cayu_ses
cellists1038563cellists
chartists14126803chartists
chastises1437703chastises
chemists152710323chemists
chutists1335583chutists
chymists18285603chymists
cists76624533c___ists
cladists1136723cladists
classisms13295523classisms
classist104010383classist_
coassist10298803coassist_
coexists1735653coexists
consists10310593consists
copyists1545993copyists
cosmisms1446223cosmisms
cosmist11311333cosmist_
cruises93514443c_ruises
crusts84916543c_ru_sts
cubists11359023c_ubists
cultists10107633cultists
cyclists1545713cyclists
czarists1966223czarists
dadaists1045583dadaists
desists83611723des_ists
fabulists1444723fabulists
faddists13235543faddists
fascisms1545663fascisms
fascist1239213fascist_
fauvists1443843fauvists
fuguists1243693fuguists
harpists1338103harpists
insists739083ins_ists
jesuits1436323jesui_ts
jujuists1442273jujuists
lawsuits1142753lawsui_ts
maists85817573ma__ists
narcists1078113narcists
naturists947513naturists
palmists12268813palmists
papists112110453pa_pists
pastises103616053pastises
racists92613323ra_cists
rapists92510753ra_pists
resists74414923res_ists
revuists1135153revuists
sacrists1039563sacrists
sadists83310853sa_dists
shists96515113__shists
suints64617783__suints
suits55028053__sui_ts
tachists1348183tachists
tanists7313653ta_nists
tsarists857303tsarists
waists97415453wa__ists

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1561145455.1
2DLD Change Limit1461621146.90621164.5
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.10825139.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.