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

151 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
fumed11611882(None) 
famed115928341famed
flumed124915261flumed
fume96727631fume_
fumer105918231fumer
fumes105224701fumes
fumet105630221fumet
fused94820441fused
fuzed185415251fuzed
aimed85626052aimed
armed86324432armed
blumed114313642blumed
bummed134211722bummed
bumped134414002bumped
bused85624492bused
cubed105519702cubed
cued76329562cu_ed
culmed114610592culmed
cured85932132cured
domed95423262domed
duded84417132duded
duked115218462duked
dumbed124012082dumbed
dumped123814492dumped
duped95118322duped
dured75025402dured
faced117727652faced
faded105025242faded
faked135225482faked
fame95639392fame_
fames105735922fames
fared95842342fared
farmed125117652farmed
fated95632132fated
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
fed76548352f__ed
feed84538902f_eed
feme96130542feme_
femes105626222femes
feted94420932feted
feuded114010002feuded
feued94715662feued
fifed125115972fifed
filed95331902filed
filmed124610362filmed
fined94930502fined
fired94829742fired
firmed125411882firmed
fixed165416952fixed
flamed124618972flamed
fled85429772f_led
flied96519432flied
flued95021252flued
fluked145112092fluked
flume106021172flume_
flumes115119732flumes
flumped15377712flumped
fluted104917162fluted
fluxed17509672fluxed
foamed126014402foamed
formed125021172formed
fouled104315972fouled
foxed165115212foxed
framed125116522framed
freed95223542freed
fremd115010322fremd
fried95322912fried
fubbed144711242fubbed
fucked164114482fucked
fud76335152fu__d
fudged125212812fudged
fuel76824732fu_el
fueled104913602fueled
fugged124615382fugged
fugled114813692fugled
fugued11478712fugued
fulled103820652fulled
fumbled153710492fumbled
fumers113613382fumers
fumets114311812fumets
fumier11310902fumier
fumy127118582fum_y
fund85624982fu_nd
funded114413892funded
funked144214112funked
funned103613952funned
furled104717052furled
furred104514432furred
fuse76429992fuse_
fusee86224582fusee
fusel85218492fusel
fuses85628422fuses
fussed104613802fussed
futzed19418982futzed
fuze166422372fuze_
fuzee175718882fuzee
fuzes175120222fuzes
fuzzed18479252fuzzed
gamed95126392gamed
gaumed104610322gaumed
gummed123811662gummed
guyed1049892guyed
homed115425422homed
hued86925852hu_ed
humid114213762humid
hummed144812672hummed
humped144015242humped
juked175714072juked
jumped183511552jumped
lamed85235292lamed
limed85426802limed
lubed85319892lubed
luged74019092luged
lumen75220902lumen
lumped114216962lumped
lured65427492lured
luted64826142luted
med66146742__med
mimed105622732mimed
muled85824432muled
mummed104411552mummed
mumped133813162mumped
mured85726702mured
mused85524582mused
muted85023382muted
named85223062named
nuked104014182nuked
numbed114111442numbed
numen74216792numen
outed65429062outed
plumed114412882plumed
puked124716222puked
puled84926522puled
pumped133915562pumped
rimed84826372rimed
rued55729792ru_ed
ruled65822522ruled
rumen74419502rumen
spumed114711542spumed
sued56537932su_ed
summed114014042summed
tamed85528512tamed
timed85223612timed
tubed85818042tubed
tumid84114022tumid
tumped114216232tumped
tuned64622312tuned
umped104717272_umped
used55722822_used

Search took 3 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 Limit538001512.44022049.2
3Display Results1511510.0463282.6
 (SQL Overall)1786911512.57969286.9
 
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.