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

152 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
parasol93955(None) 
parasols1039261parasols
caracol11310422caracol
girasol874622girasol
parabola1246652parabola
parador103311412parador
parados103816052parados
paradox17358172paradox
parafoil1345972parafoil
paragon10311022paragon
paramo102614642paramo_
paramos113213512paramos
paras76143042paras__
parasail1049232parasail
parashot13410142parashot
parasoled1246352parasoled
parol74826272par__ol
parson83817902par_son
phrasal1246162phrasal
aerosol747683aerosol
amatol838693_amatol
argol65317263_ar_gol
arson55118833_ar_son
brasil8713863_brasil
caracal11312513caracal
caracole12310363caracole
caracols12310413caracols
caracul1138823caracul
caramel11310253caramel
carassow1343253carassow
caravel1238213caravel
carol75128613car__ol
carpool1139223carpool
cresol8310213_cresol
danazol1743253danazol
farnesol11113013farnesol
girasole984423girasole
girasols984273girasols
girosol885303girosol
harass9313943haras_s
karakul1042553karakul
latosol745283latosol
marabou1147493marabou
maras75443293maras__
marasca1136823marasca
pacas96029403pacas__
paduasoy1441393paduasoy
palatal9310153palatal
paleosol1043883paleosol
papadom1466763papadom
papal95820673papa__l
papas94927493papas__
para65242173para___
parable111819773parable
parabolas1347003parabolas
parabolic1546283parabolic
parachor1546663parachor
parade94720643para_de
paraded114014263paraded
parader103914863parader
parades104121463parades
paradisal1246883paradisal
paradors113411903paradors
paradrop1344603paradrop
parae76335703para__e
parafoils1445503parafoils
paraform1546933paraform
paragoge1257153paragoge
paragons11311503paragons
parallel1047473parallel
paramour1246083paramour
parang93715513para_ng
parangs104314373parangs
paranoea1048573paranoea
paranoia10410563paranoia
paranoic1249833paranoic
paranoid11311143paranoid
parapet11317643parapet
paraph13311263para_ph
paraphs1439313paraphs
parasails1147583parasails
parasang1147333parasang
parashah1646453parashah
parashoth1753973parashoth
parasite10314843parasite
parazoan1946553parazoan
parboil1138323parboil
parcel103915473par_cel
pardon94618733par_don
pards85634333pards__
pareo74632603par_eo_
pareos87023773par_eos
pares77164483pares__
pareses94718883pareses
paresis93315093paresis
pargo86723723par_go_
pargos95719043par_gos
paris75145943paris__
parises94827183parises
parish115022353paris_h
parkas125018023parkas__
parks116134463parks__
parlor8312673par_lor
parodoi10267723parodoi
parodos103011753parodos
parole84425253par__ole
parols84722613par__ols
parral85517533par_ral
parrel84515983par_rel
parrot8320663par_rot
parrs75928673parrs__
pars67560793par_s__
parsable12311693parsable
parse75236993par_s_e
parsec105914483par_sec
parsed96323893par_sed
parser84822373par_ser
parses85534703par_ses
parsons93516873par_sons
partial92616263partial
parton84720993par_ton
partook1337313partook
parts77743373parts__
parvo107719183par_vo_
parvos116614753par_vos
passel85117003pa_ssel
patrol83213023pa_trol
pausal81511963pa_usal
person83517873per_son
perusal939193perusal
petasos948603petasos
pharaoh1545033phara_oh
phrase11109903phras_e
phrased1387383phrased
phrases12711463phrases
planosol1043823planosol
plasmasol1352183plasmasol
plimsol1143343plimsol
podsol946853p_odsol
prao66229023p_ra_o_
praos74923563p_ra_os
prase76128753p_ras_e
prases84429023p_rases
presold1059603p_resold
prison8514023p_rison
proso77222413p_roso_
prosos85718553p_rosos
pyrrol1136273pyr_rol
tarsal63315273tar_sal
varas86028193varas__
vavasor13143603vavasor
warison1037083warison

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271528.70015405.4
3Display Results1521520.0632412.7
 (SQL Overall)1786911529.16919488.6
 
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.