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

171 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
bemisting143807(None) 
befitting15236622befitting
bekissing1643502bekissing
bemiring13239602bemi_ring
bemixing20226522bemi_xing
bemusing1336612bemus_ing
besting104923922be__sting
blemishing1843512blemishing
delisting112710502delisting
demasting1338452demasting
demising122012522demis_ing
demitting13239072demitting
desisting112810382desisting
emitting112410352_emitting
existing1639072_existing
heisting123411042he_isting
misting103623382__misting
relisting102414352relisting
reminting122315102reminting
remising112516452remis_ing
remitting122412622remitting
resisting103215312resisting
admitting1345033admitting
agisting1038243_agisting
assisting1046183assisting
baiting103918883b_ai_ting
banishing1537143banishing
basting104227203b__asting
beastings12387653be_astings
beating104326873be__ating
becrusting1544603becrusting
bedighting1844173bedighting
bedimming1743643bedimming
bedirtying1742723bedirtying
beestings12335923be_estings
beeswing14255763be_eswing
begetting13186583begetting
beginning1344613beginning
begirding1434333begirding
believing1535283believing
belittling1343193belittling
belting104119133be__lting
bemeaning1436193bemeaning
bemingling1643403bemingling
bemist105216963bemist___
bemisted1368383bemist_ed
bemists113410703bemist__s
bemoaning1435953bemoaning
bemocking2034653bemocking
bepainting15144883bepainting
berating113220763be_rating
beriming13310463beri_ming
besetting12268423besetting
besieging1344763besieging
besmiling1436263besmi_ling
besmutting1553353besmutting
besotting12256873besotting
betiding1239913beti_ding
betting103921403be__tting
bevomiting1843103bevomi_ting
bewigging1743443bewigging
biting95321823b__i_ting
bitting103717293b__itting
blasting114013433b_lasting
blissing1136873b_lissing
boasting113512503b_oasting
boosting113311053b_oosting
braising113014563brais_ing
breasting1239583breasting
brisking15329473b_risking
brisling112410843b_risling
bristling1246663b_ristling
bruising11279143bruis_ing
bruiting11259973brui_ting
bursting1138703b_ursting
busting104221793b__usting
cementing1438763cementing
coexisting2044403coexisting
debiting122511203debi_ting
degusting1236163degusting
dehiscing1643733dehiscing
dementing13311043dementing
demoting12311423dem_oting
depicting1537813depicting
detesting112610323detesting
devesting14249903devesting
deviating14311083deviating
devising133111523devis_ing
easting84924303_e_asting
editing9313133_edi_ting
egesting1039013_egesting
emoting10313563_em_oting
enisling949633_enisling
enlisting1038343enlisting
evicting1437483_evicting
eviting11511373_evi_ting
exiting15311393_exi_ting
famishing1845233famishing
feasting122011323fe_asting
feinting123410833fe_inting
fisting113818123__fisting
flemishing1943493flemishing
foisting122910503_foisting
geminating1447763geminating
gemmating1576443gemmating
hemistich1946073hemistich
histing113720373__histing
hoisting123610903_hoisting
insisting1038823insisting
itemising1245883itemis_ing
jesting154317713je__sting
joisting16328503_joisting
leniting9312353leni_ting
limiting1138813limi_ting
listing84020593__listing
masting104325823__masting
mediating13311203mediating
meriting11314693meri_ting
milting103619123__milting
minting103020813__minting
missing103619073__missing
musting103221073__musting
nesting84320443ne__sting
obelising1256323obelis_ing
omitting11217743_omitting
peising103416763pe_is_ing
perishing1539533perishing
permitting1546303permitting
persisting1346653persisting
premising14412413premis_ing
recasting122414233recasting
reciting113118073reci_ting
reemitting1346633reemitting
reesting93118273re_esting
refitting132811123refitting
relishing13229183relishing
remating112322423rem_ating
remeeting12311433remeeting
remelting12311703remelting
reminding132311543reminding
remixing182810333remi_xing
renesting102514703renesting
repasting122312843repasting
rerising93017783reris_ing
resifting133512093resifting
resiting93521123resi_ting
resitting103414873resitting
resting85031183re__sting
retasting102513413retasting
retesting102614603retesting
retinting102215253retinting
retwisting1445633retwisting
revesting132814123revesting
revising122714403revis_ing
revisiting1446953revisiting
seising84018863se_is_ing
semistiff1744253semistiff
seriating10916403seriating
smiting103014443_smi_ting
tempesting1544453tempesting
tempting1357343tem_pting
testing86021053te__sting
twisting12427813_twisting
vesting114618683ve__sting
vomiting1437733vomi_ting
waisting123615213_waisting
westing115020273we__sting
whisting15329543_whisting
wisting113519743__wisting
yeasting12188923ye_asting
zesting174515333ze__sting

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411717.22020587.4
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.71923149.5
 
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.