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

181 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
fuzes17512022(None) 
fazes175527211fazes
fezes175220021fezes
fumes105224701fumes
furzes186613691furzes
fuses85628421fuses
futzes184313111futzes
fuze166422371fuze_
fuzed185415251fuzed
fuzee175718881fuzee
fuzees184910751fuzees
fuzzes175412251fuzzes
adzes155913802adzes
aures55137092aures
bizes165923662bizes
buses75936012buses
butes714535872butes
buzzes165011172buzzes
cozes166033242cozes
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cures75645432cures
cutes79438322cutes
dazes155024142dazes
defuzes20398302defuzes
dozes155226302dozes
duces86327472duces
dudes75424372dudes
dues56045502du_es
dukes105023472dukes
dunes65332172dunes
dupes86425932dupes
dures65635922dures
faces106439432faces
fades94932862fades
fakes126032482fakes
fames105735922fames
fanes84639892fanes
fares85852872fares
fates85139232fates
fauces114916152fauces
fauves125610422fauves
faves115331422faves
faxes155726652faxes
faze165630042faze_
fazed186222962fazed
feazes184514172feazes
feces105625362feces
fees76450602f_ees
feezes184412612feezes
femes105626222femes
feres86038182feres
fes66551672f__es
fetes85630142fetes
fezzes174910402fezzes
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
fizzes174512552fizzes
flees85828752flees
flies85630712flies
floes85528142floes
flues84626922flues
flukes135114192flukes
flumes115119732flumes
flutes95421782flutes
fluxes165212932fluxes
foes76543442f_oes
fores85847102fores
foxes156321092foxes
frees86131392frees
fries85535602fries
frizes184015462frizes
froes86126692froes
fubs96328792fu_bs
fucks144419252fucks
fucus105515892fucus
fudges114314492fudges
fuds86528562fu_ds
fuel76824732fu_el
fuels87117352fuels
fugles104715782fugles
fugs85730692fu_gs
fugues104511682fugues
fugus95914012fugus
fujis15379242fujis
fulls84623522fulls
fume96727632fume_
fumed116118822fumed
fumer105918232fumer
fumers113613382fumers
fumet105630222fumet
fumets114311812fumets
funds94119252funds
funest94316862funest
funks125318912funks
funs75235732fu_ns
furies95126372furies
furls85322052furls
furs76735042fu_rs
furze176815812furze_
fuse76429992fuse_
fused94820442fused
fusee86224582fusee
fusees95416402fusees
fusel85218492fusel
fusels94412452fusels
fuss76027932fu_ss
fusses94920552fusses
futzed19418982futzed
fuzil173810702fuzil
fuzils18407962fuzils
fuzz158420572fuz_z
fuzzed18479252fuzzed
fuzzy1929814512fuzzy
fyces139813642fyces
fykes156312692fykes
gauzes164710632gauzes
gazes155425912gazes
gudes74520812gudes
gules64831042gules
hazes174928322hazes
hues75235232hu_es
jubes145420742jubes
jukes165319102jukes
jupes145218552jupes
jutes125125132jutes
kues86426772ku_es
lazes145129572lazes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lures56138532lures
lutes55836662lutes
lutzes153711922lutzes
luxes124921502luxes
mazes165632172mazes
mezes167719262mezes
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
nudes64723292nudes
nukes95418122nukes
oozes145418712oozes
ouzel144612322ouzel
ouzels15408702ouzels
ouzos143210412ouzos
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
puses75532202puses
putzes174212522putzes
razes145032702razes
rubes74928412rubes
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
sizes146727762sizes
sues46247652su_es
supes75628302supes
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tuxes124316042tuxes
ukes86122812_ukes
uses44931112_uses
utes45930882_utes
wizes174723342wizes
yules84521582yules
yutzes18408412yutzes

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 Limit538001811.64032804.9
3Display Results1811810.0503620.0
 (SQL Overall)1786911811.783100219.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.