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

385 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
blitzer1844766(None) 
blither124812171blither
blitzed19336531blitzed
blitzers19417151blitzers
blitzes18408701blitzes
baiter84422552bait_er
biter75030032b_it_er
bitter84622672b_itter
blather125314202blather
blatter94415652blatter
blazer174414022bl_azer
blether12459912blether
blinder103912982blinder
blinker134110212blinker
blintze1833902blintze_
blintzes1944262blintzes
blister94415312blister
blite76225352blit_e_
blites84721212blit_es
blithe115810862blithe_
blithers134711232blithers
blitz165318132blitz__
blotter94612852blotter
flitter103413902flitter
glitter84211802glitter
glitzed18375492glitzed
glitzes17367562glitzes
glitzier1833592glitzier
liter54736342_lit_er
lither94520952_lither
litter64324852_litter
slither104112982slither
slitter73615872slitter
aglitter935093aglitter
aliener71011193aliener
aligner8108313aligner
aliner65621983ali_ner
alter54828503al_t_er
bailer85425253bai_ler
baited95319243bait_ed
baiters94619303bait_ers
baize164717393bai_ze_
baizes174315053bai_zes
banter84825333bant_er
baptizer2134893baptizer
barter85525373bart_er
baster85333593bast_er
bather115322513b_ather
batter84928873b_atter
battier93515713battier
battler94113383battler
beater84729393beat_er
beetler938033beetler
beezer174010523b_eezer
belier84423563beli__er
believer13448423believer
belittler1142493belittler
belter84720963belt_er
better84723703b_etter
bibber94613573b_ibber
bicker144819173b_icker
bidder104114863b_idder
bider85728373b_i_der
bier65531833b_i__er
bigger104315063b_igger
biker116022563b_i_ker
bilayer12347803bilayer
bilgier10358533bilgier
bilker124913443b_ilker
biller84923483b_iller
binder94422873b_inder
biner75930693b_i_ner
binger94923453b_inger
birder94915493b_irder
birler85715083b_irler
bister84922763b_ister
bite66547003b_it_e_
biters83925243b_it_ers
bites75641173b_it_es
bitsier9379073b_itsier
bitted94418483b_itted
bitten84715123b_itten
bittern94810683b_ittern
bitters94920363b_itters
bittier94211663bittier
bize155926293b_i_ze_
bizes165923663b_i_zes
bizzes163910843b_izzes
blabber10418923blabber
blacker154513513blacker
bladder11429153bladder
blader93618583bl_ader
blamer104417143bl_amer
blander103715163blander
blanker134612023blanker
blaster94017303blaster
blastier10249493blastier
blate75933783blat_e_
blathers134713793blathers
blatted104812713blatted
blatters104414093blatters
blaze165520833bl_aze_
blazed184314713bl_azed
blazers184811683bl_azers
blazes174817353bl_azes
bleaker133510533bleaker
bleater94515303bleater
bleeder10359643bleeder
bleeper11458253bleeper
blender104613843blender
blesser9329293blesser
blethers13429613blethers
blighter1466853blighter
blimey13468453bli_mey
blinded114810023blinded
blinders113911143blinders
blinked144010013blinked
blinkers14388503blinkers
blintz1788843blintz__
blipped14377193blipped
blissed10388373blissed
blisses94911513blisses
blisters104015083blisters
blistery13418713blistery
blithely16104033blithely
blithered15156123blithered
blithest1338083blithest
blitzing2035903blitzing
blizzard1942303blizzard
bloater94013423bloater
blocker15419923blocker
blogger11448313blogger
blonder104011943blonder
bloomer11419813bloomer
blooper11358533blooper
blotted103911833blotted
blotters104110983blotters
blottier10336413blottier
blower115316573bl_ower
blowier1248943blowier
blowzed22435973blowzed
blowzier2233413blowzier
blubber10399293blubber
blucher143310223blucher
bludger11419563bludger
bluer74918493bl__uer
bluffer15396883bluffer
blunder103813153blunder
blunger104112013blunger
blunter94512033blunter
blurter9419833blurter
blusher124113113blusher
bluster94215313bluster
boater84622093boat_er
boiler84319273boi_ler
boite74426323boit_e_
boites84322703boit_es
bolster93713423bolst_er
bolter83920753bolt_er
bonzer175313673b_onzer
boozer174815963b_oozer
bortzes1838223bortzes
bother115218063b_other
bottler94211883bottler
brazer174917533b_razer
briber104714053bri_ber
bridler103811073bridler
briefer1235563briefer
brier74527403bri__er
brimmer13348803brimmer
briner84519043bri_ner
bringer104213353bringer
brinier93613473brinier
brisker134210293brisker
brittler10165983brittler
britzka22132133britzka
bronzer18348493bronzer
brother123311333brother
bruiter93710633bruit_er
builder1037573builder
bunter85020383bunt_er
buster84726493bust_er
bustier93916153bustier
bustler94012563bustler
butler84220033b_utler
butter84724233b_utter
buzzer16379113b_uzzer
byliner1235723byli_ner
chitter124112963chitter
citer74827333_cit_er
cither114616683_cither
clatter94014973clatter
clicker154111883clicker
climber13449133climber
clinger103812153clinger
clinker133811663clinker
clipper133710323clipper
clutter94211663clutter
critter94113033critter
dither104417683_dither
ditzes163212423_ditzes
ditzier17307963_ditzier
either94517423_either
elater64724203elat_er
elite56230183elit_e_
elites66027123elit_es
emitter93211083emitter
filter94517633filt_er
fitter94120033_fitter
fizzer17369383_fizzer
flatter103815963flatter
flicker163610623flicker
flier86023403fli__er
flinder11319873flinder
flinger113710513flinger
flintier1136393flintier
flipper14389143flipper
flirter10318673flirter
flirtier1144893flirtier
flite85424963flit_e_
flited104616583flit_ed
flites95122443flit_es
flitted114011643flitted
flitters114312173flitters
flivver1633043flivver
fluter95316863flut_er
flutier103011553flutier
flutter104012093flutter
flytier13356503flytier
fritter103912773fritter
fritzes19329453fritzes
frizer184011283fri_zer
frizzer18446893frizzer
gaiter73819503gait_er
glazer164212263gl_azer
glibber1235163glibber
glider84614263gli_der
glimmer12437713glimmer
glintier945703glintier
glister84013343glister
glitters93710543glitters
glittery12375613glittery
glitz154916373glitz__
glitzy19404783glitz_y
goiter74116203goit_er
gritter83913353gritter
hither124417253_hither
hitter94419863_hitter
howitzer2341913howitzer
ither84617603__ither
jilter133512513jilt_er
jitter133314993_jitter
kibbitzer2651243kibbitzer
kibitzer2342033kibitzer
kilter103714343kilt_er
kiter95523213_kit_er
klister113410643klister
klutzes2064113klutzes
klutzier2142193klutzier
knitter11348133knitter
later54843923_lat_er
lather95124353_lather
latter65027893_latter
letter63722583_letter
libber104414013_libber
liber74723623_li_ber
licker125222043_licker
lieder74912323_lieder
liefer9529573_liefer
lier45942463_li__er
liever94611863_liever
lifer85822153_li_fer
lifter93814813_lifter
liger65024473_li_ger
liker95627063_li_ker
limber104316793_limber
limier83518723_limier
limmer104314793_limmer
limner84112873_limner
limper104117853_limper
liner55938923_li_ner
linger75226003_linger
linier64423793_linier
linker104321473_linker
linter64625343_linter
lintier73613803_lintier
lipper104219633_lipper
lisper84114433_lisper
lister64527253_lister
lite47054543_lit_e_
liters65429883_lit_ers
lithe84922013_lithe_
litre55421463_litre_
litres65220393_litres
litten64014873_litten
litters73422573_litters
littery103710493_littery
littler7348553_littler
liver85132963_li_ver
livier97514593_livier
livyer12426293_livyer
loiter64619173loit_er
lotter64025603_lotter
lutzes153711923_lutzes
milter84921233milt_er
miltier93214963miltier
miter75734793_mit_er
mither114218563_mither
mitier83620673_mitier
neither1037573neither
niter55028973_nit_er
obliger1035283obli_ger
omitter9298503omitter
patzer173111643_patzer
pitier84019823_pitier
plaiter93615393plait_er
plater84427693plat_er
platier93716293platier
platter93917413platter
plier75221283pli__er
plinker134010963plinker
plotter94113663plotter
plotzed19376223plotzed
plotzes18317703plotzes
politer92417073polit_er
potzer174411213_potzer
prizer174714883pri_zer
quitter162910753quitter
quizzer2434393quizzer
ritter63822423_ritter
ritzes154812943_ritzes
ritzier16297203_ritzier
seizer154114573sei_zer
seltzer1635213seltzer
siltier73413863siltier
sitter63323383_sitter
sizer145521813_si_zer
skitter113810403skitter
slater64429183slat_er
slather103816073slather
slatier74016813slatier
slicer84117603sli_cer
slicker133314533slicker
slider73918363sli_der
slier54827243sli__er
slimier93212013slimier
slimmer114211343slimmer
slinger83413833slinger
slipper113712983slipper
slithers114212953slithers
slithery14356703slithery
slitted83513313slitted
slitters84014133slitters
slittier837003slittier
sliver94116593sli_ver
slotter73314453slotter
smiter83616413smit_er
spitter94015183spitter
spitzes1849183spitzes
splitter10348443splitter
spritzer1944563spritzer
suiter64121813suit_er
swither133710993swither
thither13328103thither
tilter63417693tilt_er
titer55430613_tit_er
titfer9409523_titfer
tither94920283_tither
titter63421163_titter
triter65120593trit_er
twitter10278093twitter
ulster63712103ulst_er
uniter64619143unit_er
unitizer1746203unitizer
waiter94321253wait_er
waltzer1934383waltzer
whiter124316393whit_er
whither163510253whither
whitier133311063whitier
whitter139110893whitter
whizzer2134583whizzer
wither124321353_wither
writer94416513writ_er
writher134010853writher
zither183813083_zither

Search took 8 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.563317390.8
2DLD Change Limit1340273856.59320328.7
3Display Results3853850.1263055.6
 (SQL Overall)1786913857.28224538.7
 
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.