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

111 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
prequels193483(None) 
prequel1836341prequel_
pretzels1934032pretzels
prevues1239262prevue_s
refuels10399522_refuels
sequels1665712_sequels
briquets1934853briquets
chequers2234103chequers
cheques2136863cheque_s
coequals1944313coequals
creels84416943cre__els
crenels93711013cre_nels
crewels12438493cre_wels
croquets1955213croquets
defuels11296983_defuels
dreidels1033213dreidels
equals1538703__equals
frequent2046423frequent
frequents2144443frequents
fresnels1135233fresnels
gruels73910153gr__uels
paraquets2044593paraquets
paroquets2043643paroquets
parquets1936413parquets
pasquils1943123pasquils
peels75226423p_e__els
peepuls1134923peepu_ls
pencels113610053p_encels
perdues103511333perdue_s
periques1937653perique_s
petrels9279373p_etrels
picquets2143733picquets
piques1739093p_ique_s
piquets1836603p_iquets
piroques1944353piroque_s
plaques18317893plaque_s
preavers13910263preavers
prebills1237293prebills
prebless1236823prebless
preboils1267293preboils
prebuild1344303prebuild
prebuilds1442633prebuilds
prebuilt1247033prebuilt
prebuys1444393prebu_ys
precess11310863pre_cess
precools1237703precools
precures12312903precures
precuts111710473precu_ts
predusks1543423predusks
preeners102712813preeners
preens85020113pre__ens
prees75937173pre__e_s
prefers123713333pre_fers
prefiles133113443prefiles
prefunds1454693prefunds
preggers12236833preggers
preluders1234423preluders
preludes1137833preludes
premeds12389593pre_meds
premiers122911653premiers
premies113823063premie_s
prepregs13144763prepregs
prepress12137983prepress
prepubes1436053prepubes
prepubis1443643prepubis
prepuces1438583prepuces
prepueblo1551553prepueblo
prepupas1144133prepupas
presales10315263presales
presell939303pre_sell
presells1058283presells
presets94216423pre_sets
pressers103215023pressers
presses93523153presse_s
presters103419003presters
presumers1336373presumers
presumes1239843presumes
preteens1038123preteens
pretell938243pre_tell
pretells1047333pretells
pretzel1835143pretzel_
prevails1337663prevails
previews1634513previews
prevue1179163prevue__
prevued1337143prevue_d
prexes154915953pre_xe_s
prexies163415003prexie_s
preyers124412363pre_yers
prezes173614693pre_ze_s
propels113412843pr_opels
pulques1835323pulque_s
rebels84518133_re_bels
reels55333263_re__els
refeels10379693_refeels
refels94618053_re_fels
refuel93912623_refuel_
reheels10298253_reheels
repels84318763_re_pels
request16311023_request
requests1735743_requests
requiems1943253_requiems
requins16310203_requins
revels94220573_re_vels
revues9813903_revue_s
roques154912563_roque_s
roquets16398943_roquets
sequel1556713_sequel_
sequela1663993_sequela
sheqels1934753sheq_els
tressels8367653tressels
unequals1743733unequals

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.423422437.4
2DLD Change Limit1461621117.59319249.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911118.06222164.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.