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

269 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
fizzier1832671(None) 
dizzier16317541dizzier
fizzer17369381fizz_er
frizzier19284811frizzier
fuzzier18256521fuzzier
ditzier17307962ditzier
dizzied17236132dizzied
dizzies16279752dizzies
fierier103511192fierier
filmier1237502filmier
finnier10319952finnier
firrier103410132firrier
fishier13359852fishier
fizzed18369442fizz_ed
fizzers18357002fizz_ers
fizzes174512552fizz_es
fizziest19226072fizziest
fizzing19276402fizzing
fizzle17369712fizzle_
fizzled19357272fizzled
fizzles18339062fizzles
fozier183710662f_ozier
frizzer18446892frizz_er
frizzies19315932frizzies
frizzler19345842frizzler
frizzlier20122882frizzlier
furzier19318102furzier
jazzier2233882jazzier
muzzier17326552muzzier
ritzier16297202ritzier
sizier1514813392si_zier
sizzler15266862sizzler
tizzies15287892tizzies
vizier184311022vi_zier
whizzier2233282whizzier
airier64619363ai_rier
bilgier10358533bilgier
bitsier9379073bitsier
bittier94211663bittier
bizzes163910843bizz_es
boozier18349013boozier
brazier183911473brazier
buzzer16379113buzz_er
cozier173315143_cozier
crazier183610743crazier
crozier18369933crozier
dazzler1634713dazzler
dicier94416233di_cier
dickier143512453dickier
dictier103411863dictier
dingier93513673dingier
dinkier123411503dinkier
dippier123111393dippier
dirtier83312093dirtier
dishier113613403dishier
ditsier83010293ditsier
dizziest17266723dizziest
dizzily1934843dizzily
dozier163611633_dozier
drizzlier18122303drizzlier
faddier1237783faddier
faggier12309843faggier
fancier123412063fancier
farrier103514893farrier
fattier103513463fattier
fawnier13296363fawnier
feistier1136193feistier
fennier10339253fennier
fernier103110823fernier
fezzed18398243fezz_ed
fezzes174910403fezz_es
fibber134811933fi_bber
fiber104921133fi__ber
fibster12146533fibster
fickler16348423fickler
fiddler12309953fiddler
fielder11217413fielder
fiercer12356953fiercer
fifer115519973fi__fer
fifties132111083fifties
fighter143010773fighter
figurer11215863figurer
filcher15377793filcher
filer85433003fi__ler
filler94623623fi_ller
fillies103420253fillies
filmer114112403fi_lmer
filter94517633fi_lter
filthier1434073filthier
finder104020233fi_nder
finer85431563fi__ner
finger104920333fi_nger
firer811229253fi__rer
firmer114712443fi_rmer
fisher124917143fi_sher
fitter94120033fi_tter
fiver116024943fi__ver
fixer154717833fi__xer
fizgig2032973fizgi_g
fizgigs2142203fizgigs
fizz157519823fizz___
fizzling20264993fizzling
fizzy199015083fizz__y
flakier143910203flakier
flamier123112143flamier
flawier13378733flawier
flaxier17337983flaxier
flier86023403f__lier
flimsier1344133flimsier
flintier1136393flintier
flirtier1144893flirtier
flukier14397853flukier
flutier103011553flutier
flytier13356503flytier
foamier12339003foamier
foggier12349913foggier
folkier14359043folkier
footier104115113footier
foozler19397593foozler
forkier144311593forkier
foxier163910033f_oxier
frier85225843f__rier
frillier1136513frillier
fringier1236553fringier
friskier1535193friskier
frizer184011283friz_er
frizzed19375973frizz_ed
frizzers19335103frizz_ers
frizzes18338183frizz_es
frizziest20294143frizziest
frizzily2253143frizzily
frizzing2064803frizzing
frizzle18367043frizzle_
frizzled20325703frizzled
frizzlers20293673frizzlers
frizzles19297283frizzles
frouzier2043703frouzier
frowzier2343313frowzier
fubsier12367763fubsier
fuggier12348963fuggier
fumier11310903f_umier
funkier14349983funkier
funnier103210173funnier
furrier103513663furrier
fussier103610673fussier
fustier104213933fustier
fuzzed18479253fuzz_ed
fuzzes175412253fuzz_es
fuzziest19235793fuzziest
fuzzily2145073fuzzily
fuzzing19336183fuzzing
gauzier1735633gauzier
giddier10308723giddier
gimpier12247943gimpier
ginnier8298983ginnier
girlier8289523girlier
glazier17409353glazier
glitzier1833593glitzier
grazier173611133grazier
grizzler17335033grizzler
grizzlier18112453grizzlier
guzzler16286563guzzler
hazier184712403_hazier
hillier103413963hillier
hinkier143610793hinkier
hippier143212103hippier
hissier103410503hissier
hizzoner1942173hizzoner
icier74313753_i_cier
ickier12439923_ickier
iffier1236763_iffier
inkier104013783_inkier
inlier63615363_inlier
jazzer21376503jazz_er
jiggier16377823jiggier
jivier16438613ji_vier
kickier12349053kickier
kinkier10319433kinkier
lazier154214613_lazier
lezzie1435333lezzie_
lezzies1536203lezzies
limbier11349113limbier
limier83518723li_mier
lingier84113383lingier
linier64423793li_nier
lintier73613803lintier
lippier112710573lippier
livier97514593li_vier
mazier175013063_mazier
miffier1537023miffier
milkier133411163milkier
millier93716703millier
miltier93214963miltier
mincier113512473mincier
mingier103815293mingier
mintier93615993mintier
mirier83918363mi_rier
mirkier13319053mirkier
mistier93418713mistier
mitier83620673mi_tier
mizzen16447953mizz_en
mizzle16279993mizzle_
mizzled18327633mizzled
mizzles17329493mizzles
muzzler17257943muzzler
niftier10328713niftier
nippier11319833nippier
nittier73512243nittier
nuzzler15296493nuzzler
oilier64417233oi_lier
oozier153610253_oozier
pickier153912973pickier
piggier113510003piggier
pinier84024693pi_nier
pipier104913983pi_pier
pithier123010293pithier
pitier84019823pi_tier
pizzle16279493pizzle_
pizzles17329273pizzles
puzzler17276963puzzler
quizzer2434393quizz_er
ribbier1137593ribbier
ribier84414233ri_bier
ridgier937883ridgier
rimier83916273ri_mier
riskier1138423riskier
rozzer1437353rozz_er
schizzier2242253schizzier
scuzzier1842713scuzzier
silkier114411643silkier
sillier74017593sillier
siltier73413863siltier
sissier73711363sissier
sizer145521813si_z_er
sizzle14309613sizzle_
sizzled16367883sizzled
sizzlers16274753sizzlers
sizzles15349633sizzles
snazzier1642483snazzier
swizzler1963223swizzler
tidier73515113ti_dier
tinier63622233ti_nier
tinnier72910143tinnier
tippier113210543tippier
tipsier9268893tipsier
viewier1334983viewier
vinier93716743vi_nier
viziers19336203vi_ziers
vizir17359393vi_zi_r
whizzer2134583whizz_er
wiftier13297733wiftier
wiggier12418863wiggier
wilier93217073wi_lier
wimpier14248053wimpier
windier113412163windier
wingier113413283wingier
winier94522453wi_nier
wirier94215553wi_rier
wispier12249403wispier
withier132910493withier
wittier103910823wittier
wizzen17387203wizz_en
wizzes175110773wizz_es
woozier19347323woozier
zingier17369493zingier
zippier20308193zippier
zizzle13247313zizzle_
zizzled15315853zizzled
zizzles14307093zizzles

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272695.58024019.2
3Display Results2692690.0932892.5
 (SQL Overall)1786912696.06329472.4
 
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.