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

359 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
soldans8321040(None) 
solans64122491sol_ans
soldan73511851soldan_
soudans8309351soudans
suldans8299721suldans
dolmans10479682dolmans
goldarns1043592goldarns
jordans1566832jordans
sedans74816092s_edans
silvans10308332silvans
slogans8407982slogans
sodas64123542so_da_s
soddens9348412soddens
solan55328152sol_an_
soland75115042sol_and
solands84412342sol_ands
solano65314182sol_ano
solanos74412852sol_anos
solders83517772solders
solions7513752solions
solons65120022sol_ons
somans84619302so_mans
soudan73210352soudan_
sovrans1036482sovrans
sowans94215892so_wans
suldan72611042suldan_
sultans72411832sultans
sylvans13235892sylvans
tolans64319272tol_ans
alans55636173_al_ans
aoudads973763aoudads
beldams1237053beldams
bogans95714813bo_gans
bolas74733763bol_a_s
bolds85825283bold__s
bolsons969483bolsons
boudins10311313boudins
callans94518473callans
clans75031013_cl_ans
cleans85817053_cleans
codas84724243co_da_s
codens94821013co_dens
codlins104116243codlins
codons96119463co_dons
colas75436773col_a_s
colds85726973cold__s
coleads102911423coleads
colins85229043col_ins
collars93816573collars
collins93419833collins
colons86028683col_ons
columns1136473columns
colzas174010513colza_s
corbans11313173corbans
cordons104415763cordons
cotans81317923co_tans
dans56748153___dans
dedans85915073_dedans
dollars83311023dollars
dolman95312403dolman_
dolmas95213043dolma_s
dolmens10388693dolmens
doodads1035093doodads
elans55527753_el_ans
eolian6312593eolian_
flans85327973_fl_ans
folders113514393folders
folding123912443folding
folds95221693fold__s
foldups1332733foldups
fondant11311143fondant
fondants1246203fondants
glans65125833_gl_ans
gleans75014743_gleans
gobans94412043go_bans
goddamns1341983goddamns
goddams1233983goddams
goldarn944383goldarn
golden84411153golden_
golds75421313gold__s
goldurns1042603goldurns
gossans836783gossans
gowans105512293go_wans
guldens9356573guldens
hodads1147963ho_dads
hoddens12378803hoddens
hoddins12289373hoddins
hogans105914313ho_gans
hoidens11329083hoidens
holdall1145473holdall
holdalls1244333holdalls
holden104113953holden_
holders113715903holders
holding123514283holding
holdings13297743holdings
holds94623243hold__s
holdups1333593holdups
holidays1544103holidays
holland11349473holland
hollands12247273hollands
hollas94616903holla_s
holydays1843473holydays
honans94814503ho_nans
hondas10313353honda_s
houdahs1434243houdahs
howdahs1733613howdahs
hoydens14347403hoydens
iodins74216523io_dins
isoleads944373isoleads
isopodans1252503isopodans
jordan1468063jordan_
kalians11310183kalians
koans95818623ko__ans
kolas94822233kol_a_s
lallans74113533lallans
leans55536253__leans
loans56026463__loans
lochans1248833lochans
lodens74315063lo_dens
logans76319063lo_gans
longans84510813longans
lorans65117603lo_rans
loudens8368053loudens
lurdans837073lurdans
mildens10339933mildens
moans74624373mo__ans
modals93914453mo_dals
molars85517323mol_ars
molas75132093mol_a_s
molders103315553molders
molding114213753molding
moldings12267203moldings
molds85324833mold__s
mollahs12328283mollahs
mordant10312403mordant
mordants1137143mordants
morgans10310123morgans
nonfans1037533nonfans
oceans81211003_oceans
octans81411143_octans
odahs95610083_o_dahs
odas57230263_o_da_s
oilcans936813oilcans
olden65114853_olden_
oldies7314423_oldies
olds55926573_old__s
oleins6313523_oleins
ollas54218283_olla_s
oodlins83210513oodlins
ordains879653_ordains
organs7912913_organs
plans75731273_pl_ans
polars84419353pol_ars
polders103617373polders
poleyns1236113poleyns
polkas1239103polka_s
pollens93713303pollens
prolans9314273prol_ans
randans8313213randans
redans75421023_redans
reloans7313133reloans
roans54926443ro__ans
romans84620243ro_mans
rowans95715343ro_wans
saddens9309603saddens
salaams997703salaams
saladang1043843saladang
saladangs1142913saladangs
salads75316963sal_ads
salals65120083sal_als
salinas73116093salinas
salmons93713263salmons
salons63823693sal_ons
saloons74415323saloons
salpas85116923salpa_s
salpians1036763salpians
salsas65316133salsa_s
saltant7316773saltant
saltpans1034813saltpans
sampans112411003sampans
sandals82715203sandals
sans45153363s___ans
sarans64224433s_arans
sardana838643sardana
sardanas937813sardanas
sardars83112903sardars
scans74625103s__cans
scolders11288993scolders
scolding12278913scolding
scoldings13224133scoldings
scolds95011233scold__s
seawans10379943seawans
sedan65620423s_edan_
seitans73312303seitans
seladang1043403seladang
seladangs1142383seladangs
selahs9313213sel_ahs
selsyns1092943selsyns
selvas93812913selva_s
sendals81912263sendals
serdabs1035323serdabs
sewans95215903s_ewans
sextans14349263sextans
shamans123610903shamans
shorans102812413shorans
sialidans1042973sialidans
silane62718053sil_ane
silanes72517163sil_anes
silds65520523sild__s
silvan92810153silvan_
silvas92912183silva_s
simians959203simians
sirdars8228213sirdars
skeans104512913s_keans
slabs75322643s_l_abs
slags66525903s_l_ags
slams74927903s_l_ams
slang66324023s_l_ang
slangs75615343s_l_angs
slank95822773s_l_ank
slant55238703s_l_ant
slants64819083s_l_ants
slaps76025713s_l_aps
slats55436903s_l_ats
slaws85222713s_l_aws
slays85723683s_l_ays
slogan7539223slogan_
slovens10316573slovens
smolders11287193smolders
soaks95220293so__aks
soaps75120713so__aps
soars54732513so__ars
sobas74424253so_ba_s
socas74026183so_ca_s
socials999633socials
socman1039813socman_
soda56329383so_da__
sodden84011513sodden_
soddies92312853soddies
sodding103712733sodding
sodoms989673so_doms
sods54940213so_d__s
sofars94712783so_fars
sofas85320713so_fa_s
softas94410403softa_s
softens10347623softens
sojas124716393so_ja_s
sola45541863sol_a__
solace83415823sol_ace
solaces93116133solaces
solanin7311943sol_anin
solanins8310513solanins
solanum946403sol_anum
solanums1044433sol_anums
solar55927343sol_a_r
solate64526073sol_ate
solates73523853solates
sold54837413sold___
solder73921343sold_er
soldi65717203sold__i
soldier82812153soldier
soldiers9277773soldiers
soldo67116563sold__o
solemn838643solemn_
soles55547923sol__es
soleus64615613sol_eus
solidago1042773solidago
solidagos1142563solidagos
solidary1245103solidary
solids74116403sol_ids
solidus8338113solidus
soling74226823sol_ing
solion6616383solion_
solitons849593solitons
soloing82813803soloing
solon55026133sol_on_
solos54830793sol__os
sols45448163sol___s
solums85211333sol_ums
solunar735283solunar
solus54726983sol__us
solutes73515263solutes
solvate102710213solvate
solvates11249673solvates
solvent10310833solvent
solvents1136763solvents
solvers104414253solvers
solves95018223sol_ves
solving112910853solving
soman75024903so_man_
somas76030373so_ma_s
sonant6621953so_nant
sonants7511233so_nants
sonars64818973so_nars
sonders83820713sonders
sondes74922873sond_es
sons46049553so___ns
soprani937403soprani
soprano937003soprano
sopranos1046433sopranos
soras55041013so_ra_s
sordine82515233sordine
sordines92414073sordines
sordini8228963sordini
sordino8219443sordino
sordors8310013sordors
sords64527803sord__s
sorns55028423so__rns
soucars938423soucars
soutane7312063soutane
soutanes8312933soutanes
sovran937153sovran_
sowars94318013so_wars
sowcars1236013sowcars
sowens93613153so_wens
soyas84520913so_ya_s
soybeans1343283soybeans
sozins15510793so_zins
spans74528733s__pans
speans85417143s_peans
splats84817303spl_ats
splays114910873spl_ays
spleens937103spleens
sporrans1045523sporrans
stollens835293stollens
stolons73410243stol_ons
subdeans1137203subdeans
suddens9308783suddens
sulfas9311563sulfa_s
sultan63012593sultan_
sultana7257803sultana
sultanas8237153sultanas
sundaes8313093sundaes
suntans72111733suntans
swans84625013s__wans
sylvan12257363sylvan_
sylvas12288173sylva_s
sylvins13246243sylvins
todays10458103to_days
tolan55124013tol_an_
tolane64316583tol_ane
tolanes74216313tol_anes
tolars64817943tol_ars
tolas54532773tol_a_s
tolidins948023tolidins
tomans85419133to_mans
toucans937583toucans
uhlans937573uhl_ans
ulans54921303_ul_ans
voduns1035053vo_duns
volant9316323vol_ant
volcano1244613volcano
volcanos1344733volcanos
volvas12447993volva_s
voudons1135323voudons
wolds95420183wold__s
womans114613653wo_mans
xylans1635883xyl_ans
yulans958673yul_ans

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 Filter1786911340270.420425454.8
2DLD Change Limit1340273597.06318975.9
3Display Results3593590.1262849.2
 (SQL Overall)1786913597.60923484.2
 
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.