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

346 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
souaris731233(None) 
souari6311381souari_
houris94514582hou_ris
ouraris73512932_ouraris
safaris101110662safaris
saris54544952s__aris
soars54732512so_ar_s
sofars94712782sofar_s
solaria7312492solaria
solarise8512542solarise
solarism10810382solarism
sonars64818972sonar_s
soucars938422soucar_s
sourish10310692sou_rish
sours55230502sou_r_s
sowars94318012sowar_s
squares163714462squares
squarish2047322squarish
squarks20417182squarks
tsouris735152tsou_ris
ambaris113112163ambaris
aquaria1638043aquaria
aquarist171010083aquarist
ascaris93613323ascaris
auris55331533_au_ris
boards94616933bo_ards
boarish123911913bo_arish
boars75229603bo_ar_s
boarts84716873bo_arts
bogarts1047743bogarts
bonacis11310323bonacis
bourgs9459993bou_rgs
bourns84114063bou_rns
boyards13399323boyards
boyarism1546393boyarism
boyars115611983boyar_s
coatis85122603co_atis
cougars1038443cougar_s
coulis84018763cou_lis
coumaric1446183coumaric
coumarin1247323coumarin
coumarins1347023coumarins
courts84216173cou_rts
covaries13413253covaries
cowards1339613cowards
curaris94114773curaris
dotards937253dotards
dourahs11487253dourahs
douras75016723dou_ras
estuaries946213estuaries
feuars938653feuar_s
foulards12266463foulards
fours85521493fou_r_s
gouramis1184163gouramis
gourds8108253gou_rds
guards84611573_guards
guars65021053_guar_s
hegaris11310433hegaris
hoards104912623ho_ards
hoars85925553ho_ar_s
holards1148433holards
houri85915253hou_ri_
hours85422393hou_r_s
hubris11218973_hubris
isobares1046513isobares
isobaric1244753isobaric
isobarism1343833isobarism
isobars936593isobar_s
jouals1338933joua_ls
jowars16369653jowar_s
kauris103611533kau_ris
koumis1237623kou_mis
kouros1039183kou_ros
kukris934453_kukris
laris54737463__laris
loris55329153lo__ris
louis57322323lou__is
lours55125293lou_r_s
louvres10356523louvres
mohairs1234953mohairs
molars85517323molar_s
morris83814733mo_rris
mourns84111013mou_rns
naris55735293__naris
nonarts7311303nonarts
noris54928273no__ris
notaries8314933notaries
nourish1039703nou_rish
oars46846033_o_ar_s
oasis56422553_o_asis
okapis1235393_okapis
ooralis7312553ooralis
orris54516553_o_rris
ossuaries944553ossuaries
ourari63413543_ourari_
ourie54027303_ou_rie
ours47237563_ou_r_s
outrig72812853_outrig
outrigs82811263_outrigs
ovaries10312653_ovaries
oxalis1339223_oxalis
paris75145943__paris
polarise10513903polarise
polars84419353polar_s
pooris83916843po_oris
poulards11288233poulards
pours74623183pou_r_s
puris75332023_pu_ris
quais144618393_qua_is
quarks193810913_quarks
quarts154715933_quarts
roars55622243ro_ar_s
romajis1635913romajis
rosaria749253rosaria
rosaries8312783rosaries
rotaries8315693rotaries
sadis64930853s__adis
safari91110223safari_
saguaros944973saguaros
sahuaros1154283sahuaros
sakis95323673s__akis
salamis9313513salamis
salaries8319593salaries
samaras9312913samaras
samurais1046153samurais
sards64736183s__ards
sari45444043s__ari_
sarin55239253s__arin
sarins63932623s__arins
sarks96632463s__arks
saros55238063s__aros
sataras7315063sataras
satis55633683s__atis
satoris7317253satoris
sauries72821623sau_ries
savarin10310003savarin
savarins1139893savarins
scares85033003s_cares
scarfs114714683s_carfs
scarps104718603s_carps
scars75433533s_car_s
scarts85321493s_carts
scaurs85512053scaur_s
scours84913593scou_r_s
scurfs113210813scu_rfs
scurries102911483scurries
scurril945113scurril
sears54744913s_ear_s
sedarim1047113sedarim
senarii7269143senarii
senarius8310103senarius
serais64326133sera_is
sewars94018633sewar_s
shards104319173s_hards
shares95236413s_hares
sharia93116733s_haria
sharias102516003s_harias
sharif122917123s_harif
sharifs13279903s_harifs
sharks135019723s_harks
sharns95516983s_harns
sharps115516083s_harps
shears93820903shear_s
sherris10168803sherris
shikaris1544923shikaris
shofars1335833shofar_s
shris84221453s__hris
simars84916933simar_s
sitarist8315283sitarist
sitars65417593sitar_s
sizars154812623sizar_s
skuas95611733skua__s
slurbs8439743slu_rbs
slurps84410003slu_rps
slurries82710413slurries
slurs54123373slu_r_s
smarms105712533s_marms
smarts86218003s_marts
smears84714433smear_s
snares65329033s_nares
snarfs95113423s_narfs
snarks104815733s_narks
snarls64016873s_narls
soaks95220293so_a_ks
soaps75120713so_a_ps
soar46838673so_ar__
soared74324293so_ared
soarer64522243so_arer
soarers74118093so_arers
soaring83521893so_aring
soarings93210393so_arings
soaves94218673so_aves
sobas74424253soba__s
sobers85218863sober_s
socages101012053socages
socas74026183soca__s
sodalist9311883sodalist
sodas64123543soda__s
sofar86115493sofar__
sofas85320713sofa__s
sojas124716393soja__s
solaces93116133solaces
solands84412343solands
solanin7311943solanin
solanins8310513solanins
solanos74412853solanos
solans64122493sola_ns
solar55927343solar__
solarised1068043solarised
solarises9512703solarises
solarisms1168813solarisms
solarium1078263solarium
solariums1165923solariums
solarize17511473solarize
solarizes18511613solarizes
solates73523853solates
solatia7312253solatia
somans84619303soma_ns
somas76030373soma__s
somatic111916473somatic
sonants7511233sonants
sonar56523423sonar__
sonatas7510293sonatas
sopors85215203sopor_s
soras55041013so__ras
sorbs75022103so__rbs
sords64527803so__rds
sores55454283so__res
sori46039843so__ri_
sorns55028423so__rns
sorosis72611973sorosis
sorts54536663so__rts
sorus54527583so__rus
soubise9118793sou_bise
soucar839323soucar__
soudans8309353soudans
soughs105115623sou_ghs
soukous1136413soukous
souks94820523sou__ks
souls55127363sou__ls
sounds74616183sou_nds
soups75322943sou__ps
sour45935893sou_r__
source8410673sou_rce
sources9312173sources
soured74921863sou_red
sourer63620213sou_rer
sourest7515713sou_rest
souring83219063sou_ring
sourly93612213sou_rly
sous46947213sou___s
souses64229243sou_ses
souslik1144153souslik
sousliks1244003sousliks
soutanes8312933soutanes
souters74422603souters
souths95216603sou_ths
souvlakis1651353souvlakis
sovrans1036483sovrans
sowans94215893sowa_ns
sowar85821343sowar__
sowcars1236013sowcar_s
sowers94923443sower_s
soyas84520913soya__s
spahis11310383s_pahis
spares84834553s_pares
sparid94016933s_parid
sparids103512123s_parids
sparks124616363s_parks
spars75431543s_par_s
spears84019473spear_s
spurns84811383spu_rns
spurries102311323spurries
spurs74621523spu_r_s
spurts84814973spu_rts
squabs17429323squa_bs
squads164410293squa_ds
squalid1737053squalid
squalls1647313squalls
square154513363squar_e
squared173610563squared
squarer163410663squarer
squarers17338023squarers
squarest17338223squarest
squaring18158633squaring
squark19438113squar_k
squats153712963squa_ts
squawks23294883squawks
squaws18438783squa_ws
squires163812843squires
squirish2045113squirish
squirms18376343squirms
squirts16348013squirts
sris45434153s___ris
stairs65416333s_tairs
stares66038753s_tares
stars55836573s_tar_s
starts65423123s_tarts
stasis63116873s_tasis
stearic939423stearic
stearin7312003stearin
stearins8312143stearins
stoures74614163stou_res
stourie7469353stou_rie
stours65015633stou_r_s
sturts63915143stu_rts
subarid10310653subarid
sucres84218893s_ucres
sudaria847973sudaria
sudaries9312753sudaries
suers55128483s_uer_s
suffaris1445083suffaris
sugars7312423sugar_s
sunrise7310813s_unrise
surahs94515543s_urahs
suras55336333s_u_ras
surds65624663s_u_rds
surfs85022543s_u_rfs
surras65919533s_urras
sushis9311183s_ushis
sutras64818593s_utras
swamis114212293s_wamis
swards105415133s_wards
swarfs125612063s_warfs
swarms116112173s_warms
swears94114073swear_s
tamaris9413603tamaris
tolars64817943tolar_s
tourism939423tou_rism
tourist7313203tou_rist
tours55325893tou_r_s
tovarish1445123tovarish
towards1138783towards
tsooris734693tso_oris
tsoris63411193tso__ris
tsuris62710203tsu_ris
tzuris15286913tzu_ris
uakaris1146633uakaris
uraris63817273_uraris
votaries11312013votaries
votarist111012163votarist
wooraris1145063wooraris
yours85217883you_r_s
zoaria1548383zo_aria
zoris145320013zo__ris
zouaves1933893zouaves

Search took 9 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.813219792.1
2DLD Change Limit1340273467.97016816.4
3Display Results3463460.1262746.0
 (SQL Overall)1786913468.90920057.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.