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 “umped” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
umped10471727(None) 
amped104820511amped
bumped134414001bumped
dumped123814491dumped
humped144015241humped
imped105117981imped
jumped183511551jumped
lumped114216961lumped
mumped133813161mumped
pumped133915561pumped
tumped114216231tumped
upped103715161upped
urped84615281urped
aped78538152_aped
biped104718832biped
bummed134211722bummed
bumper123714342bumper
burped116215502burped
camped134720232camped
caped104931802caped
chumped17379492chumped
clumped143610662clumped
comped135919872comped
coped105036842coped
crumped144311222crumped
cupped134413982cupped
cusped114312042cusped
damped124315582damped
doped95326712doped
dumbed124012082dumbed
dumper114615212dumper
duped95118322duped
dupped124411642dupped
embed105014302embed
flumped15377712flumped
fumed116118822fum_ed
gaped96123532gaped
gimped123911472gimped
grumped13337332grumped
gulped104610372gulped
gummed123811662gummed
hoped115628182hoped
hummed144812672hummed
humper134115882humper
humphed1835422humphed
hyped145313332hyped
imbed105013652imbed
impede11469622impede
impel95711772impel
impend11478792impend
impled113812512impled
japed156217632japed
jumper173612372jumper
lamped114017542lamped
limped114817122limped
loped85128332loped
lumpen104010662lumpen
lumper103816652lumper
med66146742_m_ed
meed74934702_meed
moped105424732moped
muled85824432muled
mummed104411552mummed
mumper123513522mumper
mured85726702mured
mused85524582mused
muted85023382muted
numbed114111442numbed
oped76230152_oped
ped66751522__ped
pimped134913482pimped
piped105123162piped
plumped14318642plumped
pulped114612532pulped
pumper124415552pumper
pupped105013272pupped
ramped114617902ramped
raped85334622raped
riped85226432riped
romped114513652romped
roped84630802roped
rumpled123810012rumpled
siped84927682siped
slumped123710152slumped
sped76031492_sped
stumped124210152stumped
summed114014042summed
supped114415702supped
tamped114317042tamped
taped85327422taped
temped113912892temped
thumped15387412thumped
toped85631312toped
trumped12439712trumped
tupped114013232tupped
typed115815452typed
umbel93612842umbel
umber94617592umber
ump76130442ump__
umpired1235782umpired
umps85721942ump_s
unfed94614222unfed
unled64021072unled
unpeg8309362unpeg
unpen72913572unpen
unwed94114872unwed
upend85011042u_pend
upper93714262upper
urged75316032urged
used55722822u_sed
vamped144211012vamped
whumped18335632whumped
wimped144211512wimped
wiped114722082wiped

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001141.62633087.3
3Display Results1141140.0303800.0
 (SQL Overall)1786911141.749102167.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.