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

179 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
besmiles123739(None) 
besmile1137461besmile_
besmiled1335491besmiled
bastiles10313352bastiles
beguiles1146102beguiles
bemires113212832be_mires
bemixes18338652be_mixes
besides104814532bes_ides
beslimes1246952beslimes
besmokes16406362besmokes
resiles74026542res_iles
smiles84522292__smiles
aediles83413893ae_diles
bascules1236683bascules
basils85717473bas_il_s
bastile9313913bastile_
bastilles1147353bastilles
beadles103414723be_adles
beagles103212123be_agles
beamier113411943beami_er
beamiest123212763beami_est
beamily1477393beamil_y
beamless12327003beam_less
beanies93821093beani_es
beasties102514653beasti_es
becrimes1467073becrimes
bedimples1642973bedimples
bedmates1349183bedmates
bedsides1246533bedsides
bedtimes1336593bedtimes
beedies10314203beedi_es
beehives1644483beehives
beelines103312803beelines
beetles9312083be_etles
begrimes1376513begrimes
beguile1056933beguile_
beguiled1244443beguiled
beguiler1154063beguiler
beguilers1252873beguilers
beguines11127213beguines
beiges91014403be__iges
bejumbles22122443bejumbles
belies84631053be_li_es
belles85325993be__lles
bellies94023723belli_es
bemingles1444743be_mingles
bemire103312803be_mire_
bemired123410633be_mired
bemists113410703be_mists
bemixed19337053be_mixed
bemuses1139293be_muses
bennies93917313benni_es
benzines1938213benzines
benzoles1936993benzoles
bepimples1742303bepimples
berimes115216643be_rimes
berlines102315453berlines
bermes106023003berm__es
bernicles1345403bernicles
berries94423553berri_es
beses75830723bes___es
beshames1537203beshames
beshiver1634483beshiver
beshivers1743713beshivers
beside95114613bes_ide_
besieges1146003besieges
beslime1146833beslime_
beslimed1335013beslimed
besmears1234543besmears
besmiling1436263besmiling
besmirch1742133besmirch
besmirches1982163besmirches
besmoke15416623besmoke_
besmoked17405413besmoked
besmudges1542413besmudges
besmuts1134683besm_uts
bestirs9311133besti_rs
bestrides1237913bestrides
betaines10313293betaines
betides104915263be_tides
betimes115114413be_times
betises94816123be_tises
bevies114017303be_vi_es
bewailed1435343bewailed
bewailer1334863bewailer
bewailers1434233bewailers
bewails1277553bewail_s
bezils1711310603be_zil_s
biles75542143b___iles
boehmites1663023boehmites
bossies94116833bossi_es
brambles14308973brambles
bromides13219363bromides
bromines122514253bromines
bromizes21258333bromizes
bumbles134016843b_umbles
busbies113011693busbi_es
busies85525263bus_i_es
bustles93816323bus_tles
centiles103615813centiles
deciles104417713de_ciles
defiles114016843de_files
demies94825803de_mi_es
demises103719563de_mises
dermises112512023dermises
desires81316133des_ires
desmids1166603desmi_ds
despises1139433despises
despites11410313despites
destines93619663destines
ediles74016973_e_diles
ensiles72714833_ensiles
ermines9416663_ermines
espies83716803_espi_es
etoiles7411293_etoiles
exiles134816403_e_xiles
females12310663fe_males
gemmules13183213gemmules
gentiles93713523gentiles
hessites1138613hessites
hostiles11312213hostiles
jasmines1736623jasmines
jemmies18318333jemmi_es
kermises14248313kermises
miles74645073___miles
misfiles133110983misfiles
missiles103015083missiles
nestles73015463nes_tles
osmoles9138363_osmoles
outsmiles1146443outsmiles
pestles93217693pes_tles
pismires1235883pismires
refiles104122423re_files
remiges103015473re_miges
remises93423483re_mises
remixes164313873re_mixes
reptiles103913063reptiles
resailed93613063resailed
resails74616743resail_s
resales74724903res_ales
resamples1344713resamples
rescales103414563rescales
reseizes1759853reseizes
resembles1376063resembles
reshines112615443reshines
resides84523283res_ides
resile64627673res_ile_
resiled84621983res_iled
resites74027793res_ites
resizes164216843res_izes
resmelts1046143resmelts
resoles73823653res_oles
respires10311903respires
respites10513243respites
restyles1139193restyles
retiles74426993re_tiles
reviles104421353re_viles
semises93916553se_mises
seniles72618023se_niles
sessile739523sessile_
sestines82717243sestines
sextiles1537643sextiles
similes92915233_similes
smile74823913__smile_
smiled93716433__smiled
smiler83916683__smiler
smilers94113843__smilers
smiley114012303__smiley
smileys12336323__smileys
smites83921923__smites
spiles84227913__spiles
stiles64328763__stiles
temples112610893te_mples
termites10313693termites
testicles1146773testicles
textiles1536833textiles
verbiles1338913verbiles
vesicles13127073vesicles
vestiges1238243vestiges

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621798.78316641.5
3Display Results1791790.0762355.3
 (SQL Overall)1786911799.01219828.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.