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

118 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
jemmying233231(None) 
jimmying2342381jimmying
dummying17263722dummying
gemming13289152gemm_ing
hemming15269972hemm_ing
jamming19329792jamm_ing
jellying19306172jellying
jettying1933952jettying
lemming12269392lemm_ing
mummying15263722mummying
bamming144611813bamm_ing
beaming123618803beam_ing
belaying143110603belaying
bellying14359073bellying
belying133612443be_lying
bemiring13239603bemiring
bemixing20226523bemixing
bemusing1336613bemusing
berming123614833berm_ing
berrying14137383berrying
bumming143410783bumm_ing
chammying2243353chammying
damming133812743damm_ing
decaying15239453decaying
decoying15208763decoying
decrying15237413decrying
deeming113913123deem_ing
defying15328823de_fying
deifying1637633deifying
delaying133210973delaying
demising122012523demising
demoing11311753de_moing
demoting12311423demoting
denying123711293de_nying
dimming13339593dimm_ing
eddying1335293_eddying
embaying1635263_embaying
emoting10313563_emoting
emptying1634243_emptying
envying1435713_envying
espying1336193_espying
eying96117923_e__ying
ferrying15146253ferrying
gamming133112623gamm_ing
gemmating1576443gemmating
gumming133810193gumm_ing
hamming153014093hamm_ing
helming133712003helm_ing
herrying15147033herrying
humming153310673humm_ing
jambing19328533j_ambing
jeeing144512143je__eing
jeeping174010333je_eping
jeering153513043je_ering
jelling153516613je_lling
jemmied19294483jemm_ied
jemmies18318333jemm_ies
jemmy19498553jemmy___
jerking19308923je_rking
jessing153710623je_ssing
jesting154317713je_sting
jetting153815343je_tting
jeweling1935483jeweling
jewing174411423je__wing
jimminy2133373jimm_iny
jollying19316063jollying
joying173810803j__oying
jumbling20217233jumbling
jumping19319803j_umping
jurying18337763j_urying
juttying1933573juttying
keying1438043ke__ying
lamming123014583lamm_ing
lemmings13254733lemm_ings
levying1435873le_vying
maying124421153__maying
mumming114010023mumm_ing
nimming12358143nimm_ing
perming123416093perm_ing
ramming123115063ramm_ing
readying13410223readying
reaming103924013ream_ing
rebuying1436743rebuying
redrying13209023redrying
reflying15268173reflying
refrying15278903refrying
reifying1539383reifying
rekeying1637563rekeying
relaying122515153relaying
relying112914613re_lying
remaking152613303remaking
remating112322423remating
remedying1635143remedying
remising112516453remising
remixing182810333remixing
removing1439083removing
repaying142712393repaying
replying14269403replying
resaying122512453resaying
retrying122410453retrying
retying113213833re_tying
rimming123411073rimm_ing
seaming103222113seam_ing
seeming103216263seem_ing
serrying12167703serrying
shammying2042953shammying
shimmying2042533shimmying
stemming13408203stemm_ing
stimying1437503stimying
stymying1733963stymying
summing122912383summ_ing
teaming103917593team_ing
teeming103513093teem_ing
temping122710693te_mping
tempting1357343tempting
terming104016003term_ing
tomming12359243tomm_ing
wearying1546703wearying

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.420425454.8
2DLD Change Limit1461621187.29620033.2
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.76223021.3
 
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.