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

380 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
teether1034969(None) 
teeter65420311teet_er
teethe94511311teethe_
teethed11318621teethed
teethers11328711teethers
teethes103611651teethes
tether93716101t_ether
aether94213672_aether
beetler938032beetler
blether12459912blether
diether1147442diether
either94517422_either
ether84518772__ether
feather133613502feather
heather133914852heather
leather103815782leather
meeter83616502meet_er
neither1037572neither
nether94014162_nether
seethe93712482seethe_
seethed113410192seethed
seethes103613742seethes
teacher123714832teacher
teemer85515742tee_mer
teener64717502tee_ner
teenier72611142teenier
teeters74018302teet_ers
teeth87315852teeth__
telpher1235562telpher
tenter64623932tent_er
tentier73815922tentier
tester64227152test_er
testier74015642testier
tethers103815312t_ethers
tetter64322452t_etter
thither13328102thither
tither94920282t_ither
together1243742together
tother94117142t_other
tweeter10288532tweet_er
weather133513222weather
wether123315392_wether
whether16346622whether
abetter958323abetter
aethers103614943_aethers
another10289153another
anther93715063_anther
aweather1434263aweather
bather115322513_bather
beater84729393beat_er
beechen14367703beechen
beeches143413883beeches
beechier1535633beechier
beefier12329093beefier
beeper103714093bee_per
beerier93613023beerier
beetle8311673beetle_
beetled1038213beetled
beetlers1037393beetlers
beetles9312083beetles
beezer174010523bee_zer
begetter11136313begetter
belcher143511493belcher
belter84720963belt_er
bencher144113483bencher
berthed13259123berthed
besetter10137973besetter
bethel1169643_bethel
better84723703_better
blather125314203blather
blethers13429613blethers
blither124812173blither
bother115218063_bother
breather133610593breather
brother123311333brother
center84421413cent_er
centner946853centner
cither114616683_cither
comether1537253comether
couther123914623couther
deedier93011593deedier
deeper93613503dee_per
defter104215923deft_er
deter65028043_det_er
dexter143810893dext_er
dieter73516773diet_er
diethers1257453diethers
dither104417683_dither
eater54639843_eat_er
eelier64216463_eelier
eerier64320023_eerier
enter54726383_ent_er
ester54727713_est_er
etcher113912943_etcher
ethers94518413__ethers
farther1348343farther
father125116713_father
feater95224053feat_er
feathers143513243feathers
feathery17368073feathery
feebler1235823feebler
feeder103513843fee_der
feeler93215173fee_ler
fester94723513fest_er
fetcher153510393fetcher
fetter94120383_fetter
fleeter103210363fleet_er
flesher133610923flesher
fletcher16306663fletcher
fresher132612643fresher
fretter103412753fretter
frother133110153frother
further1337003further
gather104115853_gather
geekier12286393geekier
geezer16278013gee_zer
gentler8378953gentler
getter74117613_getter
gleetier934913gleetier
greeter82812673greet_er
heater94828303heat_er
heathen133410893heathen
heathers143914733heathers
heathery17349083heathery
heathier1438343heathier
heeder104216043hee_der
heeler93917313hee_ler
hefter124313923heft_er
heftier1337203heftier
hither124417253_hither
ither84617603__ither
jeerer13389933jee_rer
jester134319153jest_er
jettier14358693jettier
keener104012833kee_ner
keeper123811913kee_per
keester11319913keester
kelter103214373kelt_er
kvetcher2052813kvetcher
lather95124353_lather
leacher124014843leacher
leathern11398913leathern
leathers114215083leathers
leathery14438973leathery
lecher113415853_lecher
leeched13369503leeched
leeches123911933leeches
leerier73111503leerier
lefter93613433left_er
lethe85717303_lethe_
lethes94818083_lethes
letter63722583_letter
lither94520953_lither
loather103711003loather
meatier93214613meatier
meeker12359983mee_ker
meeters94714543meet_ers
melter83520113melt_er
meter75130323_met_er
metier83517693_metier
mither114218563_mither
mother113718643_mother
mouther123812813mouther
murther1237953murther
neater64424313neat_er
neatherd12107193neatherd
needer73614953nee_der
needier84010623needier
needler8388893needler
nester64124183nest_er
nestler73510443nestler
netter63722023_netter
nettier74211813nettier
nettler7349503nettler
neuter63713793neut_er
norther1039733norther
nother93815963_nother
other84219103__other
panther12611443panther
peacher144216073peacher
peatier94017233peatier
peeler83517383pee_ler
peeper103614803pee_per
pelter83321623pelt_er
percher143313423percher
perter84422283pert_er
pester84827593pest_er
pestier94317403pestier
peter74427593_pet_er
petter83924773_petter
pettier94213613pettier
pewter114013673pewt_er
pleather1356653pleather
pother113818853_pother
rather94319733_rather
reacher123718293reacher
reechier1336673reechier
reedier83815303reedier
reefer93314363ree_fer
reefier102912553reefier
reeker103715593ree_ker
reekier113111123reekier
reeler63822573ree_ler
reenter73217793reenter
regather1236733regather
reletter81311023reletter
renter64527413rent_er
rentier73618223rentier
resetter81511833resetter
rester63832433rest_er
reutter71010093reutter
seater64534153seat_er
seeder74320773see_der
seedier83513633seedier
seeker103615363see_ker
seemer84418043see_mer
seepier92912013seepier
seltzer1635203seltzer
setter64023723_setter
settler73410653settler
sheather1458213sheather
sheeter103814903sheet_er
skeeter113410413skeet_er
sketcher1735433sketcher
slather103816063slather
sleetier837883sleetier
slither104112983slither
smother123510203smother
soother104215033soother
souther104116303souther
steelier839183steelier
steeper93812773stee_per
steerer73113633stee_rer
stretcher1446283stretcher
swather134213593swather
sweeter103212003sweet_er
swither133710993swither
tarter64023563tart_er
tartier74123263tartier
taster64930573tast_er
tastier711817093tastier
tater54138613t_at_er
tatter64024573t_atter
tattier74216243tattier
tattler73112213tattler
tauter64318023taut_er
teachers133212393teachers
teaches122718353teaches
tearer64822903t_earer
tearier73815613tearier
teaser65421523t_easer
teated74924023teat_ed
teched124014433t_eched
techier1269243techier
tedder83312153t_edder
teemed95114873tee_med
teemers95012903tee_mers
teenager9115293teenager
teeners74415453tee_ners
teensier835573teensier
teentsier942413teentsier
teepee8314363tee_pee
teepees939263teepees
teetered9258303teetered
teething1237163teething
teethless1243703teethless
telethon1145993telethon
telfer9379893t_elfer
teller63519813t_eller
telphers1335473telphers
temper103914093t_emper
tempter11358213tempter
tenches123515523tenches
tender74121843t_ender
tenner64117103t_enner
tenoner739673tenoner
tenser64919433t_enser
tented74221003tent_ed
tenters73921103tent_ers
tenth85421833tenth__
tenthly1335743tenthly
tenths94412663tenth_s
tentie62521183tentie_
terete6319333teret_e_
termer85717253t_ermer
terrier73414963terrier
terser67317823t_erser
testae64216253testae_
tested74421523test_ed
testee64323303test_ee
testees74215913testees
testers74124543test_ers
testes65125823test_es
tetched133010773tetched
tetchier1336453tetchier
teth76327883t_eth__
tethered1238493t_ethered
teths85418513t_eth_s
tetters74320473t_etters
texture1497083texture
thatcher1635653thatcher
theater104014253theater
thewier1336063thewier
thresher1455823thresher
tighter112910683tighter
tilter63417693tilt_er
tinter63923643tint_er
titer55430613t_it_er
titfer9409523t_itfer
tithe85319703t_ithe_
tithed104115593t_ithed
tithers104216733t_ithers
tithes94720213t_ithes
titter63421163t_itter
tocher114014913t_ocher
tooter64420803toot_er
toothed113310243toothed
toothier1136423toothier
tootler73511123tootler
toter55932133t_ot_er
totter65021463t_otter
toucher124814353toucher
tougher114210983tougher
touter63821033tout_er
trasher104416123trasher
treader84113823treader
treater74219833treater
trekker1034733trekker
trencher13279313trencher
triter65120593trit_er
trothed114010973trothed
trotter73312253trotter
tsetse664693tsetse_
tsetses785453tsetses
tufter9319933tuft_er
tuftier1096603tuftier
turtler72610323turtler
tweedier1253623tweedier
tweener10306833tweener
tweeted11336583tweet_ed
tweeters11287143tweet_ers
tweezer19305763tweezer
twitcher16135343twitcher
twitter10278093twitter
tythe115210453t_ythe_
tythed13457503t_ythed
tythes12419703t_ythes
tzetze1432733tzetze_
tzetzes1532673tzetzes
untether1145163untether
ureter6313203uret_er
venter94218723vent_er
vetoer93410063_vetoer
vetter93417643_vetter
weathers143412833weathers
weeder103315513wee_der
weedier113810623weedier
weenier103210803weenier
weeper114313303wee_per
weepier12319273weepier
weeted103913793weet_ed
weever123811443wee_ver
weigher14136343weigher
welcher15319393welcher
welsher13377443welsher
welter93417383welt_er
wencher153811133wencher
wester94222893west_er
wethers135214693_wethers
wetter93919443_wetter
whetter13348803whetter
whither163510253whither
wither124321353_wither
wreather14268603wreather
writher134010853writher
wuther124511613_wuther
yester93417983yest_er
zester153617793zest_er
zestier163010223zestier
zither183813083_zither

Search took 9 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.1731032896.0
2DLD Change Limit1340273807.87617017.1
3Display Results3803800.1233089.4
 (SQL Overall)1786913808.17221866.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.