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 “beguiles” 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
beguiles114610(None) 
beguile1056931beguile_
beguiled1244441beguiled
beguiler1154061beguiler
beguilers1252881beguilers
beguines11127211beguines
begrimes1376512begrimes
beguine1068502beguine_
begulfs1333752begu_lfs
besmiles1237392besmiles
guiles73919282__guiles
aediles83413903ae_diles
aegises8311373aeg_ises
aiguilles1043073aiguilles
baggies113814853baggi_es
bagpipes1543403bagpipes
bastiles10313353bastiles
baubles113611863b_aubles
beadles103414733be_adles
beagles103212123be_agles
beanies93821093beani_es
beauties10229523beauties
becrimes1467073becrimes
becurses1236723becurses
bedquilts2141633bedquilts
bedsides1246533bedsides
bedtimes1336593bedtimes
beduins1039123bedui_ns
bedunces1345513bedunces
beedies10314203beedi_es
beehives1644483beehives
beelines103312803beelines
beetles9312083be_etles
befuddles1642023befuddles
begalled1236033begalled
begalls10319163beg_alls
begazes1937963beg_azes
begins94415303beg_i_ns
begirdles1342493begirdles
begirds1134883beg_irds
begrime1276553begrime_
begrimed1475213begrimed
begrims1276763begri_ms
begrudges1472363begrudges
beguiling1334853beguiling
begulf1238903begu_l_f
begulfed1552603begulfed
begums11429493begu__ms
beiges91014413be__iges
bejumbles22122443bejumbles
belies84631053be_li_es
belles85325993be__lles
bellies94023723belli_es
bemires113212833be_mires
bemixes18338653be_mixes
bemuddles1542453bemuddles
bemuses1139293bemu_ses
bemuzzles2162193bemuzzles
bennies93917313benni_es
benzines1938213benzines
benzoles1936993benzoles
berimes115216643be_rimes
berlines102315453berlines
bernicles1345403bernicles
berries94423553berri_es
besides104814533be_sides
beslimes1246953beslimes
besmile1137463besmile_
besmiled1335503besmiled
betaines10313293betaines
betides104915263be_tides
betimes115114413be_times
betises94816123be_tises
bevies114017303be_vi_es
bewailed1435343bewailed
bewailer1334863bewailer
bewailers1434233bewailers
bewails1277553bewail_s
bezils1711310603be_zil_s
biggies113813523biggi_es
biles75542143b___iles
boggles113411823bog_gles
bogies94724313bog_i_es
bogles95020833bog__les
boucles113113003b_oucles
bougies103715183bougi_es
boules84925973b_ou_les
boulles93114123b_oulles
bruises93212913b_ruises
buggies114613813buggi_es
bugles94822443b__ugles
builds9378493b__uilds
butles84423913b__utles
centiles103615813centiles
deciles104417723de_ciles
decuples1395283decuples
defiles114016843de_files
ediles74016983_e_diles
egises7312493_eg_ises
ensiles72714833_ensiles
equines161811593_equines
equites162212493_equites
etoiles7411293_etoiles
exiles134816403_e_xiles
ferules103112723feru_les
gentiles93713523gentiles
guides84118283__guides
guilds8388353__guilds
guile64521133__guile_
guiled84315383__guiled
guilts74111233__guilts
guises74216313__guises
gules64831043__gu_les
legumes1036633legu_mes
ligules82210923ligu_les
megilps1233563meg_ilps
negliges1034833negliges
neguses837933negu_ses
preguides1344863preguides
rebuilds1143503rebuilds
refiles104122423re_files
regales83520793reg_ales
regilds996673reg_ilds
regimes104514743reg_imes
regives115014213reg_ives
regulus836523regu_lus
reptiles103913063reptiles
requires17168703requires
requites171511763requites
resiles74026543re_siles
retiles74426993re_tiles
reviles104421353re_viles
segues7412073segu__es
seniles72618023se_niles
sextiles1537643sextiles
tequilas1743283tequilas
textiles1536833textiles
veggies1237553veggi_es
vegies104314273veg_i_es
venules104011483venu_les
verbiles1338923verbiles

Search took 8 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.440406115.9
2DLD Change Limit1461621416.48322545.4
3Display Results1411410.0632238.1
 (SQL Overall)1786911416.98625578.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.