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

201 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
besmile113746(None) 
besmiled1335491besmiled
besmiles1237391besmiles
bastile9313912bastile
beamily1477392beamily
beguile1056932beguile
bemire103312802be_mire
beside95114612bes_ide
beslime1146832beslime
besmoke15416622besmoke
resile64627672res_ile
sessile739522sessile
smile74823922__smile
aedile73716653ae_dile
balmily14216463balmily
barmie103816393barmi_e
bascule1136573bascule
basil75122273bas_il_
basils85717473bas_ils
bastiles10313353bastiles
bastille1047993bastille
beadily1378843beadily
beadle93314683be_adle
beagle93612593be_agle
beamier113411943beamier
beaming123618803beaming
beamish14259293beamish
beamlike16115843beamlike
beanie83618593beani_e
beastie92412433beasti_e
becrime1387053becrime
bedimple1543133bedimple
bedlike14369533bedlike
bedmate1239433bedmate
bedside1156843bedside
bedtime1236973bedtime
beefily1535613beefily
beehive1554033beehive
beelike13379783beelike
beeline93314723beeline
beetle8311673be_etle
begrime1276553begrime
beguiled1244443beguiled
beguiler1154063beguiler
beguiles1146103beguiles
beguine1068503beguine
beige81515373be__ige
bejumble2172773bejumble
belie75630383be_li_e
belike124616283be_like
belive115415303be_live
belle75827833be__lle
bemingle1346103be_mingle
bemired123410633be_mired
bemires113212833be_mires
bemist105216953be_mist
bemix165011453be_mi_x
bemixed19337053be_mixed
bemixes18338653be_mixes
bemixt174510363be_mixt
bemuse1038943be_muse
benzine1839343benzine
benzole1837133benzole
bepimple1642503bepimple
berime105317333be_rime
berline93716853berline
berme96022943berm__e
berming123614833berming
bernicle1245443bernicle
beshame1447483beshame
beshiver1634483beshiver
besides104814533bes_ides
besiege1035413besiege
beslimed1335013beslimed
beslimes1246953beslimes
besmear1134833besmear
besmiling1436263besmiling
besmirch1742133besmirch
besmoked17405413besmoked
besmokes16406363besmokes
besmudge1442283besmudge
besmut10310653besm_ut
besmuts1134683besmuts
bespake15436963bespake
bespoke15468113bespoke
bestial9311643bestial
besting104923923besting
bestir8311163besti_r
bestirs9311133bestirs
bestride1138613bestride
betaine9413783betaine
betide95115973be_tide
betime105914833be_time
betise85616273be_tise
bewail1189583bewail_
bewailed1435343bewailed
bewailer1334863bewailer
bewails1277553bewails
bezil163812883be_zil_
bezils1711310603be_zils
bile66147183b___ile
boehmite1583153boehmite
bossily1237563bossily
bramble133710033bramble
bromide12269583bromide
bromine112915243bromine
bromize20238823bromize
bumble124216893b_umble
bushily15268893bushily
busily112211503bus_ily
bustle84015483bus_tle
centile94217183centile
decile94619213de_cile
defile105216663de_file
demise94618323de_mise
desire7415303des_ire
desmid1048363desmi_d
desmids1166603desmids
despise1038683despise
despite10410123despite
destine83719953destine
edile64819493_e_dile
ensile62616473_ensile
ermine8416923_ermine
etoile6312263_etoile
exile126117653_e_xile
febrile1237153febrile
female11310553fe_male
fertile10311733fertile
festive1339773festive
fissile10269653fissile
fusile94313493fus_ile
gemmily1534603gemmily
gemmule12173233gemmule
gentile83515293gentile
hessite1038993hessite
hostile10312553hostile
jasmine1636643jasmine
messily12298813messily
mile66352573___mile
misfile122611553misfile
missile92815403missile
nestle63013953nes_tle
osmole8128513_osmole
outsmile1046973outsmile
penile82219603pe_nile
pensile92713543pensile
peskily1635083peskily
pestle83215843pes_tle
pismire1135353pismire
refile95122373re_file
remise84221953re_mise
reptile93914083reptile
resail64418733resail_
resailed93613063resailed
resails74616743resails
resale64025543res_ale
resample1244673resample
rescale93215473rescale
reseize1639553reseize
resemble1247313resemble
reshine102816943reshine
reside74224933res_ide
resiled84621983res_iled
resiles74026543res_iles
resite64128453res_ite
resize154117723res_ize
resmelt9411773resmelt
resole64624183res_ole
respire9411543respire
respite9513033respite
restive10315933restive
restyle1038763restyle
retile65929673re_tile
revile94921613re_vile
sectile9311973sectile
sedile73517233se_dile
semple103212753se_mple
senile63420213se_nile
servile10310643servile
sestine73017923sestine
sextile1438573sextile
simile83115633_simile
smiled93716433__smiled
smiler83916683__smiler
smiles84522293__smiles
smiley114012303__smiley
smite75224873__smite
spile75230083__spile
stile54931573__stile
temple102811333te_mple
tensile72612733tensile
termite9313893termite
testicle1037443testicle
testily102910803testily
textile1437223textile
verbile1249863verbile
vesicle12217923vesicle
vespine1237903vespine
vestige1137433vestige
zestily19167563zestily

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.1561145455.1
2DLD Change Limit1340272016.17321711.8
3Display Results2012010.0603350.0
 (SQL Overall)1786912016.38927968.5
 
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.