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

140 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
prequel183634(None) 
prequels1934831prequels
pretzel1835142pretzel
prevue1179162prevue_
prevued1337142prevued
prevues1239262prevues
refuel93912622_refuel
sequel1556712_sequel
briquet1838833briquet
cheque2036663cheque_
chequer2135153chequer
cheques2136863cheques
coequal1844943coequal
creel75121483cre__el
crenel84213063cre_nel
crewel114310483cre_wel
croquet1859683croquet
cruel74815903cr__uel
defuel10348933_defuel
dreidel934473dreidel
equal1449823__equal
frequent2046423frequent
fresnel1035893fresnel
gruel66014743gr__uel
ireful948713irefu_l
paraquet1948793paraquet
paroquet1947283paroquet
parquet18311583parquet
pasquil1843923pasquil
peel65535613p_e__el
peepul1035783peepu_l
pencel103812923p_encel
perdue93912633perdue_
perdues103511333perdues
perique1837523perique_
periques1937663periques
petrel83111533p_etrel
picquet2047743picquet
pique16410173p_ique_
piqued1836213p_iqued
piques1739093p_iques
piquet17412353p_iquet
piroque1844353piroque_
piroques1944353piroques
plaque17317643plaque_
plaques18317893plaques
preaged11612333preaged
preanal9310713preanal
preaver121011613preaver
prebill1138803prebill
preboil1148953preboil
prebuild1344303prebuild
prebuilt1247033prebuilt
prebuy1357423prebu_y
prebuys1444393prebuys
precool1139013precool
precure11312553precure
precured1339993precured
precures12312903precures
precut102016533precu_t
precuts111710473precuts
predial103815413predial
predusk1443773predusk
pree67044733pre__e_
preed85128123pre__ed
preen75925053pre__en
preened103214993preened
preener93114833preener
prees75937173pre__es
prefer113813203pre_fer
prefile123413183prefile
prefund1335733prefund
prelude1038013prelude
preluded1236473preluded
preluder1135733preluder
preludes1137833preludes
premeal11310523premeal
premed114617763pre_med
premeet11615153premeet
premen105017803pre_men
premie103617993premie_
premier113515633premier
premies113823063premies
premune1138933premune
preoral9312673preoral
prepill1147583prepill
prepped11329903prepped
prepreg12165963prepreg
prepubes1436053prepubes
prepuce1337833prepuce
prepuces1438583prepuces
prepueblo1551553prepueblo
prepupa1064023prepupa
prepupal1164263prepupal
presale9416353presale
prese75228383pre_se_
presell939303presell
preset84430983pre_set
pressed103317313pressed
presser93717623presser
presses93523153presses
prester93519623prester
presume11310303presume
presumed1337973presumed
presumer1247583presumer
presumes1239843presumes
preteen939873preteen
pretell938243pretell
pretzels1934033pretzels
prevail1238243prevail
preview1536473preview
prexes154915953pre_xes
prexies163415003prexies
preyed125313203pre_yed
preyer114413733pre_yer
prezes173614693pre_zes
propel103714063pr_opel
pulque1736213pulque_
pulques1835323pulques
rebel73421293_re_bel
reel45240533_re__el
refeel93913243_refeel
refel84920813_re_fel
refuels10399523_refuels
reheel93610823_reheel
repel74921403_re_pel
request16311023_request
requiem1836113_requiem
requin15310713_requin
revel84423163_re_vel
revue81114453_revue_
revues9813903_revues
roque144812133_roque_
roques154912563_roques
roquet154415893_roquet
sequela1663993_sequela
sequels1665713_sequels
sheqel1846523sheq_el
tressel73010893tressel
unequal1644483unequal

Search took 7 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 Limit1340271406.09321996.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.54527301.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.