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

123 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
fuzed18541525(None) 
fazed186222961fazed
fumed116118821fumed
fused94820441fused
futzed19418981futzed
fuze166422371fuze_
fuzee175718881fuzee
fuzes175120221fuzes
fuzzed18479251fuzzed
adzed166012542adzed
bused85624492bused
buzzed17408472buzzed
cubed105519702cubed
cued76329562cu_ed
cured85932132cured
dazed165919362dazed
defuzed21447042defuzed
dozed165619352dozed
duded84417132duded
duked115218462duked
duped95118322duped
dured75025402dured
faced117727652faced
faded105025242faded
faked135225482faked
famed115928342famed
fared95842342fared
fated95632132fated
faxed166220532faxed
fayed126422152fayed
faze165630042faze_
fazes175527212fazes
feazed195112632feazed
fed76548352f__ed
feed84538902f_eed
feezed19439992feezed
feted94420932feted
feuded114010002feuded
feued94715662feued
fezes175220022fezes
fezzed18398242fezzed
fifed125115972fifed
filed95331902filed
fined94930502fined
fired94829742fired
fixed165416952fixed
fizzed18369442fizzed
fled85429772f_led
flied96519432flied
flued95021252flued
fluked145112092fluked
flumed124915262flumed
fluted104917162fluted
fluxed17509672fluxed
fouled104315972fouled
foxed165115212foxed
freed95223542freed
fried95322912fried
frized193510682frized
fubbed144711242fubbed
fucked164114482fucked
fud76335152fu__d
fudged125212812fudged
fuel76824732fu_el
fueled104913602fueled
fugged124615382fugged
fugled114813692fugled
fugued11478712fugued
fulled103820652fulled
fume96727632fume_
fumer105918232fumer
fumes105224702fumes
fumet105630222fumet
fund85624982fu_nd
funded114413892funded
funked144214112funked
funned103613952funned
furled104717052furled
furred104514432furred
furze176815812furze_
furzes186613692furzes
fuse76429992fuse_
fusee86224582fusee
fusel85218492fusel
fuses85628422fuses
fussed104613802fussed
futzes184313112futzes
fuzees184910752fuzees
fuzil173810702fuzil
fuzz158420572fuz_z
fuzzes175412252fuzzes
fuzzy1929814512fuzzy
gazed165520332gazed
guyed1049892guyed
hazed185222202hazed
hued86925852hu_ed
juked175714072juked
lazed154925842lazed
lubed85319892lubed
luged74019092luged
lured65427492lured
luted64826142luted
mazed175523872mazed
muled85824432muled
mured85726702mured
mused85524582mused
muted85023382muted
nuked104014182nuked
oozed154214262oozed
outed65429062outed
ouzel144612322ouzel
puked124716222puked
puled84926522puled
putzed18409112putzed
razed155027982razed
rued55729792ru_ed
ruled65822522ruled
sized155519242sized
sued56537932su_ed
tubed85818042tubed
tuned64622312tuned
used55722822_used
zed135431172__zed

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 Limit538001231.65632487.9
3Display Results1231230.0333727.3
 (SQL Overall)1786911231.782100275.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.