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

141 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
parasols103926(None) 
parasol939551parasol_
caracols12310412caracols
girasols984272girasols
parabola1246652parabola
parabolas1347002parabolas
paradors113411902paradors
parados103816052parado_s
parafoils1445502parafoils
paragons11311502paragons
paramos113213512paramo_s
parasails1147582parasails
parasoled1246352parasoled
parols84722612par__ols
parsons93516872par_sons
aerosols847213aerosols
amatols938183_amatols
argols74514613_ar_gols
arsons63917213_ar_sons
brasils9410973_brasils
caracals12310753caracals
caracol11310423caracol_
caracole12310353caracole
caracoles13310073caracoles
caraculs1238033caraculs
caramels1238803caramels
carassows1442933carassows
caravels1337443caravels
carols85124983car__ols
carpools1237883carpools
cresols939653_cresols
danazols1843083danazols
farnesols12102743farnesols
girasol874623girasol_
girasole984423girasole
girasoles1083713girasoles
girosols984653girosols
harass9313943haras__s
harasses11311033harasses
karakuls1142083karakuls
latosols845003latosols
marabous1249063marabous
marascas1247383marascas
marasmus1244473marasmus
paduasoys155983paduasoys
palatals1037773palatals
paleosols1143993paleosols
papadoms1575923papadoms
parable111819773para_ble
parables121613563parables
parabolic1546283parabolic
parachors1647403parachors
paraders113113113paraders
parades104121463para_des
parador103311413parado_r
paradores12259653paradores
paradoses122510253paradoses
paradox17358173parado_x
paradoxes19267293paradoxes
paradrops1444963paradrops
parafoil1345973parafoil
paraform1546933paraform
paraforms1645563paraforms
paragoge1257153paragoge
paragoges1347253paragoges
paragon10311023parago_n
parallels1145273parallels
paramo102614643paramo__
paramour1246083paramour
paramours1345653paramours
parangs104314373para_ngs
paranoea1048563paranoea
paranoeas1147523paranoeas
paranoia10410563paranoia
paranoias11410443paranoias
paranoic1249833paranoic
paranoics1347653paranoics
paranoid11311143paranoid
paranoids1248913paranoids
parapets1239763parapets
paraphs1439313para_phs
paras76143043para___s
parasail1049233parasail
parasang1147333parasang
parasangs1246033parasangs
parashah1646453parashah
parashahs1744743parashahs
parashot13410143parashot
parashoth1753973parashoth
parasite10314843parasite
parasites11313153parasites
parazoan1946553parazoan
parazoans2045603parazoans
parboils1237433parboils
parcels113712663par_cels
pardons103817623par_dons
pareos87023773par_eo_s
pareses94718883pares_es
paresis93315093pares_is
pargos95719043par_go_s
parises94827183paris_es
parishes13314753parishes
parlors9312913par_lors
parlous9414293par_lous
parodos103011753parodo_s
parol74826273par__ol_
parole84425253par__ole
paroles95025883par__oles
parous84024163par__ous
parrals94414573par_rals
parrels94713493par_rels
parrots9312743par_rots
parsable12311693parsable
parsecs11429923par_secs
parsers94118153par_sers
parses85534703par_s_es
parson83817903par_so_n
partials101911953partials
partons94620513par_tons
parvos116614753par_vo_s
passels93913023pa_ssels
patrols93513513pa_trols
persons93717013per_sons
perusals1047143perusals
petasos948603petaso_s
pharaohs1644493phara_ohs
phrasal1246163phrasal_
phrases12711463phras_es
planosols1143943planosols
plasmasols1452153plasmasols
plimsols1242973plimsols
podsols1056513p_odsols
praos74923563p_ra_o_s
prases84429023p_ras_es
presold1059603p_resold
prisons9313223p_risons
prosos85718553p_roso_s
pyrrols1235403pyr_rols
tarsals72512603tar_sals
vavasors14153653vavasors
warisons1136903warisons

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621417.98618302.3
3Display Results1411410.0602350.0
 (SQL Overall)1786911418.48221067.1
 
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.