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 “sacrists” 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.

160 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
sacrists103956(None) 
sacrist9315421sacrist_
sacristy1345101sacristy
aorists74215832_aorists
aurists74615782_aurists
narcists1078112narcists
racists92613322rac_ists
sacrings11278922sacrings
sacristan1143572sacristan
sacristans1243072sacristans
sacristies1276032sacristies
sadists83310852sa_dists
satirists958922satirists
schists1248542s_chists
scripts11509372s_cripts
tachists1348182tachists
tsarists857302tsa_rists
accosts11107993_accosts
across8312643_acros_s
afrits9311903_afri_ts
ageists848493_ageists
agists75713173_a_gists
amorists10411333amorists
aorist64827873_aorist_
arises65233803_a_rises
arista6415293_a_rista
aristas7413523_a_ristas
aristo6414033_a_risto
aristos7312373_a_ristos
arrests73312683_arrests
arrises71617583_arrises
artists74215593_artists
ascribes1246193ascribes
assists738473_assists
astricts1049463astricts
aurist65027253_aurist_
autists73814853_autists
backlists17117413backlists
backrests1744983backrests
baptists1236723baptists
barista9310813ba_rista
baristas1039723ba_ristas
bassists1037183bassists
becrusts1244843becrusts
cambists1437023cambists
casuists1036523casuists
cists76624533__c_ists
crests85218703__crests
crises84529433__crises
crisis83716343__crisis
crisps104411513__crisps
crista8311803__crista
crits75527573__cri_ts
crusts84916543__crusts
cyclists1545713cyclists
czarists1966223czarists
dacoits1079073dacoi_ts
dadaists1045583dadaists
diarists9410363diarists
encrusts1045283encrusts
escapists1344253escapists
faddists13235543faddists
fascists1336613fascists
fauvists1443843fauvists
florists1138813florists
grists74716483__grists
harpists1338103harpists
incrusts1036253incrusts
jurists14409123_jurists
karsts106012943ka_r_sts
lariats7615053la_riats
lyrists1036963_lyrists
maists85817573ma__ists
metrists1039853metrists
narcisms1267263narcisms
narcist9512443narcist_
naturists947513naturists
pachisis15268823pachisis
pacifists1645063pacifists
palmists12268813palmists
papists112110453pa_pists
parises94827183pa_rises
patriots1038053patriots
psalmists1344073psalmists
purists94014073_purists
querists1736543querists
rachises131412413rachises
racisms112310813rac_isms
racist82822793rac_ist_
rapists92510753ra_pists
sacbuts1166473sac_buts
sachets123914103sac_hets
sackbuts1644053sackbuts
sackings15389633sackings
sacrals93311793sacr_als
sacring103115983sacri_ng
sacrums11388043sacr_ums
sadisms10359113sa_disms
sadist74221353sa_dist_
saints65122423sa__ints
salariats947823salariats
sapphists1644103sapphists
sarcasms1244983sarcasms
sarcinas1039273sarcinas
sarins63932623sa_ri_ns
saris54544953sa_ri__s
sarodists1056593sarodists
saroses73619333sa_roses
satanists948233satanists
satirises9410193satirises
satirist8313503satirist_
saurians837763saurians
sauries72821623sauri_es
sawdusts1242333sawdusts
scariest101615943scariest_
scarious10610203scarious
scarlets10178573scarlets
scarts85321493scar__ts
schisms1437173s_chisms
schist11312653s_chist_
scribes113713203s_cribes
scries85226823s_cri_es
scrimps13517903s_crimps
scrims104615933s_cri_ms
scrips105316033s_cri_ps
script105717903s_cript_
scrives124414273s_crives
seacoasts1144193seacoasts
seacrafts1443703seacrafts
secrets9311773secr_ets
sexists14267673s_exists
shists96515113s__hists
shrifts1335963s_hrifts
sitarists949373sitarists
soloists869153soloists
sophists1347293sophists
spirits94112623spiri_ts
sprints94113773s_prints
sprits85122533s_pri_ts
statists8310163statists
stockists15194563stockists
stylists11207023stylists
subsists1037993subsists
sucrases10310253sucrases
sucroses1039933sucroses
sumoists1046733sumoists
sunrises8310693sunrises
tachisms1567143tachisms
tachist12613293tachist_
tachiste1356213tachiste
tachistes1466043tachistes
tacrines10310563tacrines
tanists7313653ta_nists
tourists838313tourists
tsarisms1056653tsa_risms
tsarist7712253tsa_rist_
tzarists1755693tzarists
verists103613673_verists
waists97415453wa__ists
wrists95415643__wrists

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.420425454.8
2DLD Change Limit1461621606.78321548.3
3Display Results1601600.0602666.7
 (SQL Overall)1786911607.26324602.9
 
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.