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

381 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
philters139817(None) 
philter12108211philter_
philtres1396511philtres
chillers133710922chillers
chitters133711172chitters
filters103816552_filters
halters104619802_halters
hillers103718732_hillers
hinters103719582_hinters
hitters104717592_hitters
jilters144211962_jilters
kilters113813602_kilters
milters93619092_milters
painters103013022painters
palters94021682p_alters
pelters93720312p_elters
philtered1545492philtered
philtra12103682philt_ra
philtre12105212philt_re
philtred14114182philtred
pilfers1238962p_ilfers
pointers103013722pointers
poulters103911052poulters
printers103214902printers
psalters10227712psalters
quilters17228432quilters
shelters113412812shelters
shifters14319862shifters
tilters73315952_tilters
whitters14359402whitters
alters64924223__alters
bailers94221353bail_ers
baiters94619303bai_ters
belters93819413_belters
bilkers134711863_bilkers
billers94720833_billers
bisters93922613_bisters
biters83925243_bi_ters
bitters94920363_bitters
blisters104015083blisters
boilers93417063boil_ers
bolters94017803_bolters
builders1146743builders
ceilers93912533ceil_ers
chanters134016743chanters
chapters154012133chapters
charters134115583charters
chatters134213953chatters
cheaters133613513cheaters
chiders135312943chi_ders
chiggers1535563chiggers
childes134211273childe_s
chiles115425303chil_e_s
chilies124218303chilie_s
chiller124112183chiller_
chimers144515143chi_mers
chippers173510883chippers
chirpers15358133chirpers
chitter124112963chitter_
cholers124215203chol_ers
chunters133910903chunters
citers85022983_ci_ters
coilers93619903coil_ers
cointers103616413cointers
colters93522443_colters
coulters103614313coulters
critters103511323critters
dieters83216433_dieters
dilaters92513063_dilaters
diluters9288113_diluters
drifters12417913drifters
drillers9429723drillers
emitters10349643emitters
exalters1536653exalters
exilers14419733exil_ers
fainters11349693fainters
falters103916473_falters
filers94623723_fil_ers
fillers104320213_fillers
filmers124211293_filmers
filter94517633_filter_
fitters104517753_fitters
flirters11337933flirters
flitters114312173flitters
frillers11349873frillers
fritters113810783fritters
gaiters83516543gai_ters
gilders94212463_gilders
gillers84216903_gillers
glisters93912603glisters
glitters93710543glitters
goiters84014443goi_ters
grifters12389233grifters
grillers93810813grillers
gristers94013403gristers
gritters94210633gritters
guilders1035513guilders
hafters134614333_hafters
hailers104017263hail_ers
halers94926913_hal_ers
halter94420883_halter_
haltere103614713_haltere
halteres113414603_halteres
halvers133311423_halvers
haters94930403_h_aters
hatters104221523_hatters
heaters104225223_heaters
hefters134312003_hefters
heisters113413133heisters
hellers103619833_hellers
helpers123311853_helpers
hiders104919653_hi_ders
hikers135014353_hi_kers
hiller94421633_hiller_
hilted104016043_hilte_d
hiltless11297123_hiltless
hilts86924413_hilt__s
hinders113718503_hinders
hingers113420213_hingers
hinter94021303_hinter_
hipsters13268793_hipsters
hirers94518063_hi_rers
hissers104112313_hissers
hitless103211193_hitless
hitter94419863_hitter_
hoisters113513483hoisters
holders113715903_holders
hollers103818233_hollers
holsters113211943_holsters
hooters104520473_hooters
hullers103616263_hullers
hunters103915733_hunters
hurters103413643_hurters
inters64328053__inters
jailers144114043jail_ers
jilter133512513_jilter_
jitters144314473_jitters
jointers15289323jointers
jolters143711993_jolters
keisters123212043keisters
kelters113813753_kelters
killers114215583_killers
kilter103714343_kilter_
kiters105218593_ki_ters
klisters123910483klisters
knitters12336623knitters
leisters83312823leisters
lifters104313783_lifters
linters73822633_linters
listers74026533_listers
liters65429883_li_ters
litters73422573_litters
loiters74116613loi_ters
mailers94420333mail_ers
meisters103313843meisters
melters93918313_melters
milers84625163_mil_ers
milkers134411613_milkers
millers93621343_millers
milter84921233_milter_
minters93822473_minters
misters93927513_misters
miters84328783_mi_ters
moilers93615203moil_ers
molters93816973_molters
moulters103510783moulters
nailers73215893nail_ers
niters64624213_ni_ters
oilers64721193_oil_ers
omitters10277653omitters
ophites12310103ophi_te_s
painter93814563painter_
palmers113513623p_almers
palter84423263p_alter_
pasters94531733p_asters
paters84935833p__aters
patters94825193p_atters
pedlers103013273pedl_ers
peelers93615593peel_ers
pelites93821993pelite_s
pelter83321623p_elter_
pensters103012123pensters
peripters1368123peripters
pesters93827093p_esters
peters86624593p__eters
petters93722363p_etters
pewters124113353p_ewters
phatter123810203phatter_
phellems1544543phellems
philabegs1741923philabegs
philanders1644273philanders
philately1743963philately
philibegs1741793philibegs
philomels1643503philomels
philtering1646253philtering
philtrum1542813philtrum
phizes20389133phi_ze_s
phloems1433523ph_loems
piasters102912813piasters
pickers153718093p_ickers
piecers114112253p_iecers
piers75926333p_i__ers
pikers124717393p_i_kers
pilasters1138223p_ilasters
piles74742613p_il_e_s
pileus84514943p_il_eus
pilfer1139163p_ilfer_
pillars9313493p_illars
pilsners1035533p_ilsners
pincers113916503p_incers
pinders103720473p_inders
pingers104020743p_ingers
pinkers134118603p_inkers
pinners93518603p_inners
pipers104318663p_i_pers
pishers123815753p_ishers
pissers95014753p_issers
pistes85325633p_iste_s
pitiers93812653p_itiers
plaisters1137813plaisters
plaiters103512633plaiters
planters102915323planters
plasters103518133plasters
platers93924093p_laters
platters103415283platters
pleaters103613793pleaters
pliers84715153p__liers
plighters1545533plighters
plinkers14309393plinkers
plotters104011553plotters
plyers114912983p__lyers
pointer93814933pointer_
pointes93216753pointe_s
poisers94214433poi_sers
polders103617373p_olders
polers84225643p_ol_ers
policers12259993policers
politer92417073politer_
pollers93420023p_ollers
pollsters1137173pollsters
polluters1135033polluters
poofters1336923poofters
poolers94217423pool_ers
porters93722703p_orters
posters93928013p_osters
potters94024343p_otters
poulter93712013poulter_
pouters94221873p_outers
powters124015663p_owters
praters94921653p_raters
prealters1147773prealters
presters103419003presters
pricers113915063pri_cers
prickers163710673prickers
priers84521193pri__ers
primers114215673pri_mers
prinkers143010383prinkers
printer93917303printer_
printery13318433printery
prizers183911843pri_zers
psalter9247813psalter_
psaltery13224733psaltery
pulers83820283p_ul_ers
pullers93618483p_ullers
pulpers114612283p_ulpers
pulsers94213153p_ulsers
punsters103310583punsters
punters93617043p_unters
putters94219193p_utters
quieters17248733quieters
quilter16279803quilter_
quitters17238523quitters
railers74420663rail_ers
realters83614043realters
refilters1236103refilters
reinters82614773reinters
rioters73615513_rioters
ritters74020623_ritters
roisters83615553roisters
sailers73822323sail_ers
salters73622253_salters
schillers14285663schillers
shatters113313913shatters
sheeters113111863sheeters
shellers112812583shellers
shelter103214963shelter_
shelvers14388813shelvers
shickers173012823shickers
shielders1334763shielders
shiers94921753shi__ers
shifter132911083shifter_
shikkers14326523shikkers
shimmers15269413shimmers
shiners104015943shi_ners
shippers153012313shippers
shirkers15319583shirkers
shitless11249243shitless
shivers133714833shi_vers
shooters112811583shooters
shouters113510623shouters
shunters113210753shunters
shutters113611353shutters
shysters14106463shysters
sifters103714793_sifters
sillers73822103_sillers
silvers104714043_silvers
sinters74024083_sinters
sisters73721593_sisters
sitters74221553_sitters
skelters12349373skelters
skirters12337243skirters
skitters12349553skitters
slitters84014133slitters
smelters103310513smelters
smilers94113853smil_ers
smiters93414363smi_ters
snifters11318613snifters
spelters103912243spelters
sphincters1742073sphincters
spillers103311703spillers
spitters104113383spitters
splinters11277923splinters
splitters11307323splitters
spoilers10238633spoil_ers
sprinters11329363sprinters
stinters83312753stinters
suiters73618883sui_ters
swelters113110193swelters
swifters14277483swifters
swillers11299113swillers
tailers73720183tail_ers
thalers106212263thal_ers
theaters114211903theaters
thinkers15308703thinkers
thinners11327753thinners
thirsters1235233thirsters
thrillers1244473thrillers
tilers63523503_til_ers
tillers73418743_tillers
tilter63417693_tilter_
tinters74221113_tinters
titers64526413_ti_ters
titters74219623_titters
toilers74116263toil_ers
trillers83613493trillers
twisters11268173twisters
twitters11296773twitters
uniters73814173uni_ters
upholders1543643upholders
upholsters1542733upholsters
uplifters1463283uplifters
vaulters11206173vaulters
veilers103911823veil_ers
wailers103916803wail_ers
waisters113811523waisters
waiters104218623wai_ters
welters103516063_welters
whalers13529703whal_ers
whetters14246653whetters
whickers20297983whickers
whiffers2064493whiffers
whiles124418013whil_e_s
whimpers18276613whimpers
whiners134011573whi_ners
whingers15358723whingers
whippers18329043whippers
whirlers14286053whirlers
whiskers18306773whiskers
whispers16266993whispers
whistlers1595163whistlers
whitens13428733whi_tens
whiter124316393whi_ter_
whites123919883whi_te_s
whiteys16396153whi_teys
whitter139110893whitter_
whittlers1594333whittlers
whizzers2233423whizzers
wilders113513503_wilders
willers103517913_willers
winters103720483_winters
writers105513493wri_ters

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 Filter1786911461620.470380193.6
2DLD Change Limit1461623816.93621073.0
3Display Results3813810.1562442.3
 (SQL Overall)1786913817.56223630.1
 
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.