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

138 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
soloists86915(None) 
poloists10910521poloists
soloist7915891soloist_
colonists112512502colonists
colorists112313592colorists
holists104413962hol_ists
oboists937902_oboists
ologists939442_ologists
oologists1039852oologists
pollists10910822pollists
poloist91016322poloist_
sodomists1255922sodomists
solecists1187072solecists
soloistic1147332soloistic
solonets838232solonets
sophists1347292sophists
sumoists1046732sumoists
volosts1036562volo_sts
ableists1036543ableists
altoists848753altoists
aorists74215833ao_rists
apologists1348883apologists
biologists1349433biologists
bongoists1244843bongoists
boosts86115013bo_o_sts
cellists1038563cellists
coexists1735653coexists
cohosts12398813coho_sts
colonises112814013colonises
colonist102617933colonist_
colorisms132810793colorisms
colorist102818993colorist_
colossus1045183colossus
consists10310593consists
copyists1545993copyists
cosmists1237993cosmists
cultists10107633cultists
delists84414173del_ists
dodoisms1244523dodoisms
ecologists13310923ecologists
egoists887073_egoists
enlists749393enl_ists
enologists11310623enologists
eulogists1046653eulogists
florists1138813florists
foists95413983__foists
geologists1279163geologists
glosts74513813_glo_sts
hoboisms1545563hoboisms
hoists95516023__hoists
holisms123811113hol_isms
holist94723213hol_ist_
hornists11208833hornists
joists134711033__joists
judoists1643653judoists
lists56628693__l_ists
locoisms1256143locoisms
lookists1245713lookists
melodists1246633melodists
molests93311563mol_ests
monists93614783mo_nists
monodists1247703monodists
motorists1149913motorists
myologists1648203myologists
neologists1139773neologists
oboist8312683_oboist_
odists749853_o_dists
ologist8313833_ologist_
oologist9313493oologist_
orologists1149823orologists
otologists1149633otologists
palmists12268813palmists
polemists1348603polemists
pollist9816603pollist_
prologists13311173prologists
psalmists1344073psalmists
relists73817053rel_ists
roosts64916323ro_o_sts
sacrists1039563sacrists
sadists83310853s_adists
sarodists1056593sarodists
schists1248543s_chists
sciolists1147213sciolists
scolioses1155613scolioses
scoliosis1144743scoliosis
serologists12410123serologists
sexists14267673s_exists
sexologists1947253sexologists
shists96515113s__hists
simonists1146763simonists
sinologists1257673sinologists
slalomists1283313slalomists
slits56128853s_l_i_ts
sloids73712693s_loi_ds
slots54830533s_lo__ts
sodalists1038153sodalists
sodomist1157633sodomist_
soffits1335093soffi_ts
solarises9512703solarises
solarisms1168813solarisms
soldiers9277773soldiers
solecises1189103solecises
solecisms1396703solecisms
solecist10910783solecist_
solerets839693solerets
soleuses838073soleuses
solicits10311023solicits
solids74116403sol_i_ds
solidus8338113sol_idus
solions7513753sol_ions
solipsists1252953solipsists
soloing82813803soloi_ng
solonetz1744853solonetz
solons65120023solo__ns
solos54830793solo___s
solvents1136763solvents
soots55536213so_o__ts
sophisms1546653sophisms
sophist12311573sophist_
soroses73117483soro_ses
sorosis72611973soro_sis
sorosises947303sorosises
soubises10107993soubises
soviets1087293so_viets
splints94511743spl_ints
splits85416413spl_i_ts
statists8310163statists
stockists15194563stockists
stylists11207023stylists
subsists1037993subsists
sumoist9311613sumoist_
syllogists14175173syllogists
tourists838313tourists
ufologists1445423ufologists
urologists1148413urologists
violists1137663viol_ists
volost9412643volo_st_
zoologists2047173zoologists

Search took 10 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 Limit1461621388.64016916.9
3Display Results1381380.0632190.5
 (SQL Overall)1786911389.12319586.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.