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

476 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
philter1210821(None) 
philters1398171philters
philtre12105211philtre
chiller124112182chiller
chitter124112962chitter
filter94517632_filter
halter94420882_halter
hiller94421632_hiller
hilted104016042_hilted
hinter94021302_hinter
hitter94419862_hitter
jilter133512512_jilter
kilter103714342_kilter
milter84921232_milter
painter93814562painter
palter84423262p_alter
pelter83321622p_elter
phatter123810202phatter
philtered1545492philtered
philtra12103682philtra
philtred14114182philtred
philtres1396512philtres
pilfer1139162p_ilfer
pointer93814932pointer
politer92417072politer
poulter93712012poulter
printer93917302printer
psalter9247812psalter
quilter16279802quilter
shelter103214962shelter
shifter132911082shifter
tilter63417692_tilter
whiter124316392whi_ter
whitter139110892whitter
alter54828503__alter
bailer85425253bail_er
baiter84422553bai_ter
belter84720963_belter
bilker124913443_bilker
biller84923483_biller
bister84922763_bister
biter75030033_bi_ter
bitter84622673_bitter
blister94415313blister
boiler84319273boil_er
bolter83920753_bolter
builder1037573builder
ceiler84013963ceil_er
chanter123919733chanter
chapter144213853chapter
charter123918303charter
chaster124718503chaster
chatter124416643chatter
cheater124816963cheater
chicer134513603chi_cer
chider125116053chi_der
chiefer1536863chiefer
chigger1436003chigger
childe124711213childe_
childes134211273childes
chile105626893chil_e_
chiles115425303chil_es
chilies124218303chilies
chilled133310933chilled
chillers133710923chillers
chillier13328423chillier
chimer135517203chi_mer
chipper163912583chipper
chirker16429323chirker
chirper14359963chirper
chitters133711173chitters
choler113717153chol_er
chunter123911483chunter
citer74827333_ci_ter
coiler84421593coil_er
cointer93616723cointer
colter84625093_colter
coulter94115603coulter
critter94113033critter
dieter73516773_dieter
dilater83515653_dilater
diluter8319663_diluter
drifter11348703drifter
driller84311883driller
emitter93211083emitter
eviler94811893evil_er
eviller1056673eviller
exalter1437563exalter
exiler134712183exil_er
fainter103611053fainter
falter94519053_falter
filer85433003_fil_er
filler94623623_filler
filmer114112403_filmer
filters103816553_filters
fitter94120033_fitter
flirter10318673flirter
flitter103413903flitter
friller104111743friller
fritter103912773fritter
gaiter73819503gai_ter
gilder84415533_gilder
giller74519733_giller
glister84013343glister
glitter84211803glitter
goiter74116203goi_ter
grifter113810493grifter
griller84513353griller
grister83915413grister
gritter83913353gritter
guilder945913guilder
guiltier934493guiltier
hafter124815883_hafter
hailer94720343hail_er
haler85033523_hal_er
halted105019603_halted
haltere103614713_haltere
halters104619803_halters
hater85034753_h_ater
hatter94724873_hatter
heater94828303_heater
hefter124313923_hefter
heister103613623heister
heller93322513_heller
helper114313093_helper
hider95024083_hi_der
higher134610893_higher
hiker125119393_hi_ker
hilar85418143_hil_ar
hilled104022223_hilled
hillers103718733_hillers
hillier103413963_hillier
hilt75850713_hilt__
hilts86924413_hilt_s
hinder104120063_hinder
hinger104723333_hinger
hinted104318323_hinted
hinters103719583_hinters
hipper133818023_hipper
hipster12288783_hipster
hirer85423123_hi_rer
hisser94713793_hisser
histed104420243_histed
hither124417253_hither
hitters104717593_hitters
hoister103714203hoister
holder104619653_holder
holier94921623_holier
holler93520613_holler
holster103512213_holster
hooter94123933_hooter
hotter94720083_hotter
huller93919103_huller
hunter94817773_hunter
hurter93915853_hurter
iller54821293__iller
inter55028493__inter
jailer134316683jail_er
jilted144111353_jilted
jilters144211963_jilters
jitter133314993_jitter
jointer14379713jointer
jolter133513093_jolter
keister113011573keister
kelter103214383_kelter
killer104917953_killer
kilted113613833_kilted
kilters113813603_kilters
kiter95523213_ki_ter
klister113410643klister
knitter11348133knitter
leister73212753leister
lifter93814813_lifter
lilted73715373_lilted
linter64625343_linter
lister64527253_lister
liter54736343_li_ter
litter64324853_litter
loiter64619173loi_ter
mailer84724183mail_er
meister93114163meister
melter83520113_melter
milder93818453_milder
miler75733063_mil_er
milker124814323_milker
miller84625413_miller
milted93919943_milted
milters93619093_milters
miltier93214963_miltier
minter84425103_minter
mister84728563_mister
miter75734793_mi_ter
moiler84017263moil_er
moister94015373moister
molter84119423_molter
moulter93812423moulter
nailer64119363nail_er
niter55028973_ni_ter
oiler54628283_oil_er
oilier64417233_oilier
omitter9298503omitter
ophite11410563ophi_te_
ophites12310103ophi_tes
painted104214633painted
painters103013023painters
paintier1048793paintier
paler75436933p_al_er
palier85023563p_alier
pallier94417163pallier
palmer105816543p_almer
palters94021683p_alters
paster85734373p_aster
pater74740723p__ater
patter84628263p_atter
pearter9412743pearter
pedler93614623pedl_er
peeler83517383peel_er
pelite84323003pelite_
pelites93821993pelites
pelted94617763p_elted
pelters93720313p_elters
penster92811953penster
peripter1278753peripter
perter84422283p_erter
pester84827593p_ester
peter74427593p__eter
petter83924773p_etter
pewter114013673p_ewter
phellem1435833phellem
philabeg1642313philabeg
philander1544063philander
philately1743963philately
philibeg1642423philibeg
philomel1544083philomel
philtering1646253philtering
philtrum1542813philtrum
phizes20389133phi_zes
phloem1335713ph_loem
phonier122710633phonier
phylae14458733phylae_
phylar14437373phyl_ar
phyle134111153phyl_e_
piaster93012883piaster
picker144422173p_icker
piecer105213083p_iecer
pier66035293p_i__er
piker115622843p_i_ker
pilar75221503p_il_ar
pilaster1038163p_ilaster
pile65649693p_il_e_
pilea75123953p_il_ea
piled85232993p_il_ed
pilei74021783p_il_ei
piles74742613p_il_es
pilfers1238963p_ilfers
pillar8314023p_illar
pilled94222753p_illed
piloted10310323p_iloted
pilsner935343p_ilsner
pincer104019173p_incer
pinder94523453p_inder
pinger94324093p_inger
pinier84024693p_inier
pinker125322443p_inker
pinner84521503p_inner
piper96523193p_i_per
pipier104913983p_ipier
pisher114317753p_isher
pisser84416383p_isser
piste75824603p_iste_
pistes85325633p_istes
pitier84019823p_itier
pitted94319593p_itted
plaister1068013plaister
plaiter93615393plaiter
planter94017803planter
plaster93318693plaster
plater84427693p_later
platter93917413platter
pleater93916333pleater
plier75221283p__lier
plighter1476623plighter
plinker134010963plinker
plotter94113663plotter
plyer106214333p__lyer
pointe84619313pointe_
pointed103813983pointed
pointers103013723pointers
pointes93216753pointes
pointier1038303pointier
poiser84217243poi_ser
polder94019253p_older
poler74431793p_ol_er
policer113112683policer
polite83625073polite_
poller83921853p_oller
pollster1037103pollster
polluter1035403polluter
poofter1237163poofter
pooler83819843pool_er
porter84224413p_orter
poster84129173p_oster
potter83926983p_otter
poulters103911053poulters
pouter83923983p_outer
powter114116033p_owter
prater84825353p_rater
prealter1048863prealter
prester93519623prester
pricer103918293pri_cer
pricier113313113pricier
pricker154013413pricker
prier75027763pri__er
prilled104713003prilled
primer105118683pri_mer
primmer134310163primmer
prinker133412743prinker
printed104016373printed
printers103214903printers
printery13318433printery
privater13158533privater
privier122910453privier
prizer174714883pri_zer
psalters10227713psalters
psaltery13224733psaltery
puler74826623p_ul_er
puller83820813p_uller
pulper103513273p_ulper
pulser84215193p_ulser
punster92911103punster
punter84320023p_unter
putter83921443p_utter
quieter162810333quieter
quilted17319313quilted
quilters17228433quilters
quitter162910753quitter
railer64524933rail_er
realter73716313realter
refilter1137153refilter
reinter73116843reinter
rioter64817283_rioter
ritter63822423_ritter
roilier7311523roilier
roister73516203roister
sailer63526103sail_er
salter64325083_salter
schiller13296473schiller
shalier103116423shalier
shatter103615703shatter
sheeter103814913sheeter
sheller103515893sheller
shelters113412813shelters
shelver134211063shelver
shicker163914823shicker
shielder1235183shielder
shier85428943shi__er
shifted14359983shifted
shifters14319863shifters
shiftier1436343shiftier
shikker13277023shikker
shilled113313623shilled
shimmer143310873shimmer
shiner93820873shi_ner
shinier104113143shinier
shipper143514043shipper
shirker143711343shirker
shirtier1137943shirtier
shitted114212053shitted
shittier1137313shittier
shiver124517373shi_ver
shooter103013993shooter
shorter103515503shorter
shouter103213083shouter
shriller1136823shriller
shunter103611733shunter
shutter103712143shutter
shyster13116563shyster
sifter94516233_sifter
siller64026063_siller
silted74020013_silted
siltier73413863_siltier
silver93815813_silver
sinter63625923_sinter
sister64421583_sister
sitter63323383_sitter
skelter113610003skelter
skirter11338483skirter
skitter113810403skitter
slitter73615873slitter
smelter93311913smelter
smiler83916683smil_er
smiter83616413smi_ter
snifter10349623snifter
spelter94113703spelter
sphincter1642233sphincter
spiller92914333spiller
spitter94015183spitter
splinter10329703splinter
splitter10348443splitter
spoiler93310683spoil_er
sprinter103810813sprinter
stiller73414303stiller
stilted83511473stilted
stinter73614513stinter
suiter64121813sui_ter
svelter10359673svelter
swelter103711173swelter
swifter13318053swifter
swiller103211663swiller
tailer63823733tail_er
thaler94613103thal_er
theater104014253theater
thicker163611023thicker
thinker143610683thinker
thinner10358973thinner
thirster1135673thirster
thither13328103thither
thriller1165553thriller
tiler56131023_til_er
tiller64222543_tiller
tilted74616863_tilted
tilters73315953_tilters
tinter63923643_tinter
titer55430613_ti_ter
titter63421163_titter
toiler63918283toil_er
triller74215893triller
triter65120593tri_ter
twister10308953twister
twitter10278093twitter
uniter64619143uni_ter
upholder1444083upholder
upholster1442683upholster
uplifter1363903uplifter
uptilted1174683uptilted
vaulter10257713vaulter
veiler93814353veil_er
viler86324163_vil_er
wailer93720323wail_er
waister103812383waister
waiter94321253wai_ter
welter93417383_welter
whaler124611973whal_er
whetter13348803whetter
whicker19359773whicker
whiffer19105323whiffer
while115418693whil_e_
whiled134514133whil_ed
whiles124418013whil_es
whimper17297723whimper
whiner124516633whi_ner
whinger1410810913whinger
whinier134110633whinier
whipper173611383whipper
whirler13307603whirler
whirlier14175293whirlier
whisker17367933whisker
whisper15298013whisper
whisted144010013whisted
whistler1496313whistler
white114920303whi_te_
whited134814083whi_ted
whiten124111923whi_ten
whites123919883whi_tes
whitey154911883whi_tey
whither163510253whither
whitier133311063whitier
whitters14359403whitters
whittler1495193whittler
whizzer2134583whizzer
wilder103616473_wilder
wilier93217073_wilier
willer94021063_willer
wilted103915713_wilted
winter94222803_winter
writer94416513wri_ter

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.390458182.1
2DLD Change Limit1340274766.53320515.4
3Display Results4764760.1702800.0
 (SQL Overall)1786914767.09325192.6
 
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.