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

108 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
bemocking203465(None) 
becking164416072be__cking
bedecking1934282bedecking
bemoaning1435952bemoaning
besmoking18114612besmo_king
blocking174510572b_locking
mocking163614452__mocking
recocking18138372recocking
redocking17126782redocking
relocking16137682relocking
smocking17349102_smocking
backing165523443b__acking
beaching164114143be_aching
beaconing1436633beaconing
becloaking1944883becloaking
becoming1538163beco_ming
beflecking2243033beflecking
befogging1773413befogging
befooling1535053befooling
befouling1534983befouling
beholding1634233beholding
behooving1843743behooving
behoving1734913beho_ving
behowling1843683behowling
belching16349153be_lching
belonging1335913belonging
bemeaning1436193bemeaning
bemiring13239603bem_iring
bemisting1438073bemisting
bemixing20226523bem_ixing
bemock1636173bemock___
bemocked1934073bemock_ed
bemocks1735373bemock__s
bemusing1336613bem_using
benching163411343be_nching
beraking153612973be_raking
besotting12256873besotting
betaking153010153be_taking
beworming1734553beworming
blacking174213603b_lacking
bonking144116373b__onking
booking143618383b__ooking
borking144716173b__orking
bricking173911403b_ricking
broking143514823b_ro_king
brooking153710703b_rooking
bucking163617573b__ucking
chocking204011013_chocking
clocking174312413_clocking
cocking163619983__cocking
crocking174313443_crocking
decking153915593de__cking
decocting1538123decocting
defrocking2143153defrocking
demarking1736773demarking
demobbing1743493demobbing
demoing11311753demo__ing
demoting12311423demo_ting
deticking1736043deticking
docking153615013__docking
embosking1843963_embosking
emoting10313563_emo_ting
evoking1536413_evo_king
flocking183410873_flocking
frocking18309573_frocking
gecking154111363ge__cking
havocking2242773havocking
hocking173417243__hocking
hummocking24101863hummocking
kecking134111883ke__cking
knocking14245943_knocking
locking143718153__locking
mammocking2052393mammocking
mimicking2043873mimicking
mucking163213823__mucking
necking143913893ne__cking
nocking143615113__nocking
peacocking2143313peacocking
pecking164017783pe__cking
pocking163916763__pocking
rebooking16146393rebooking
recking144319923re__cking
recooking16148543recooking
recorking16149643recorking
relooking14167143relooking
remaking152613303rem_aking
remarking1638893remarking
remolding1338163remolding
removing1439083remo_ving
repacking1838283repacking
reracking1639313reracking
resoaking1439373resoaking
restocking1745703restocking
retacking1658973retacking
revoking1637803revo_king
reworking17136873reworking
rocking143619633__rocking
shocking184311543_shocking
smacking173510763_smacking
smockings18264283_smockings
smoking143210523_smo_king
socking143518603__socking
stocking152912503_stocking
trocking153612423_trocking
uncocking1836233uncocking
undocking1735653undocking
unlocking1636073unlocking
yocking173712373__yocking

Search took 9 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 Limit1486411087.56319653.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.04522211.4
 
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.