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

358 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
emitters1034964(None) 
embitters13334721embitters
emitter93211081emitter_
omitters10277651omitters
remitters11328401remitters
admitters1244552admitters
bitters94920352_bitters
chitters133711162chitters
critters103511312critters
demisters1249202demisters
embitter12245622embitter_
emitted103010852emitte_d
emoters94712872em_oters
emptiers1275192emptiers
fitters104517742_fitters
flitters114312172flitters
fritters113810782fritters
glitters93710542glitters
gritters94210632gritters
hemipters1645682hemipters
hitters104717582_hitters
imbitters13274502imbitters
jitters144314462_jitters
knitters12336622knitters
litters73422562_litters
matters94421752_matters
meisters103313842meisters
milters93619082_milters
minters93822462_minters
misters93927502_misters
miters84328772_mi_ters
mithers123516732_mithers
mittens9349882_mittens
mutters94117132_mutters
omitter9298502omitter_
permitters1444622permitters
quitters17238522quitters
remitter102810322remitter_
remittors11256282remittors
ritters74020612_ritters
sitters74221542_sitters
skitters12349542skitters
slitters84014132slitters
smatters104011712smatters
smiters93414362smi_ters
smithers13369792smithers
spitters104113382spitters
titters74219612_titters
twitters11296772twitters
whitters14359402whitters
abetters1057173abetters
abutters1056983abutters
admittees1243273admittees
admitter1135113admitter_
amities9317383amitie_s
ammeters1237693ammeters
baiters94619303bai_ters
batters94626013_batters
begetters12135033begetters
belittlers1242023belittlers
besetters11136633besetters
betatters1134963betatters
betters94422093_betters
bisters93922603_bisters
biters83925233_bi_ters
bitter84622673_bitter_
bittern94810683_bittern
bitterns10428943_bitterns
blatters104414093blatters
blisters104015083blisters
blithers134711233blithers
blitzers19417153blitzers
blotters104110983blotters
butters94521713_butters
cementers1338303cementers
chatters134213933chatters
chitter124112963chitter_
citers85022973_ci_ters
cithers124315753_cithers
cittern9339133_cittern
citterns10318113_citterns
clatters103313903clatters
clutters103210343clutters
cointers103616403cointers
cotters94323433_cotters
critter94113033critter_
critturs10374593critturs
cutters94218953_cutters
demister11310223demister_
demitted12288773demitte_d
dempsters1435273dempsters
depicters1435823depicters
dieters83216423_dieters
dimeters11411083dimeters
dithers114016153_dithers
dotters83715973_dotters
drifters12417913drifters
easters75125683e_asters
eaters65535943e__aters
edifiers12336673edifiers
editors839423edi_tors
editress944933editress
eiders74321363e_i_ders
either94517423e_ither_
elaters74420183e_laters
elites66027123eli_te_s
embers104116183em__bers
embittered1542543embittered
embowers15236453embowers
emeers83314183em__eers
emenders11319033emenders
emeutes938013emeute_s
emigres1037673emigre_s
emirates101214843emirate_s
emirs76116163emi___rs
emits75421473emi_t__s
emitting112410353emitting
emmers104013223em__mers
emoter85415193em_oter_
emotes84620283em_ote_s
empalers12226743empalers
empowers15276843empowers
emptier1187603emptier_
empties11712243emptie_s
enfetters1244463enfetters
enlisters937103enlisters
enmities10611353enmitie_s
enters64425643e__nters
enticers10139093enticers
epimers11109493epi_mers
epistlers1154113epistlers
epithets1345763epithets
erecters102611613erecters
esters64627733e__sters
ethers94518413e__thers
evictees1344583evictees
evictors13276853evictors
evites94916473evi_te_s
exacters1736773exacters
exalters1536653exalters
exciters1736323exciters
exilers14419733exi_lers
exitless1534883exitless
fainters11349693fainters
fetters103517903_fetters
filters103816543_filters
fitter94120033_fitter_
flatters113814203flatters
flirters11337933flirters
flitter103413903flitter_
flutters114010813flutters
fretters113410303fretters
fritter103912773fritter_
gaiters83516533gai_ters
getters84216093_getters
gittern8337503_gittern
gitterns9326563_gitterns
glisters93912603glisters
glitter84211803glitter_
glittery12375613glittery
goiters84014433goi_ters
grifters12389233grifters
gristers94013403gristers
gritter83913353gritter_
gutters83715503_gutters
hatters104221523_hatters
heisters113413133heisters
hemipter1545583hemipter_
hesitaters1374853hesitaters
hinters103719573_hinters
hitter94419863_hitter_
hoisters113513473hoisters
imbitter12265283imbitter_
imitates10310503imitate_s
imitators1147003imitators
imputers1235813imputers
inters64328043__inters
jilters144211953_jilters
jitter133314993_jitter_
jittery17346443_jittery
jointers15289323jointers
jotters143413803_jotters
keisters123212043keisters
kilters113813593_kilters
kiters105218583_ki_ters
kittens11347583_kittens
klisters123910483klisters
knitter11348133knitter_
knotters12276143knotters
lamisters1157123lamisters
leisters83312823leisters
letters73819853_letters
lifters104313773_lifters
limiters10249323limiters
linters73822623_linters
listers74026523_listers
liters65429873_li_ters
litter64324853_litter_
littery103710493_littery
loiters74116613loi_ters
lotters73921063_lotters
masters94628923_masters
maters85032383_m_aters
matter84325343_matter_
mattery123810713_mattery
mattes85624533_matte_s
meeters94714543_meeters
meister93114163meister_
melters93918313_melters
meters85625833_m_eters
metiers93312843_metiers
midterm12316013_midterm
midterms13284853_midterms
milers84625163_mi_lers
milkers134411613_milkers
millers93621333_millers
milter84921233_milter_
mimers105520183_mi_mers
mincers113714843_mincers
minders103720113_minders
miners84126633_mi_ners
minsters103813913_minsters
minter84425103_minter_
misers85025703_mi_sers
mister84728563_mister_
misterm114314513_misterm
misterms123711333_misterms
miter75734793_mi_ter_
miterers10219683_miterers
mites75141803_mi_te_s
mither114218563_mither_
mitier83620673_mitier_
mitres83922073_mitre_s
mitten83914093_mitte_n
mitts75523753_mitt__s
mixers154513563_mi_xers
molters93816973_molters
mooters93818623_mooters
mothers123717623_mothers
mottes85523693_motte_s
mottlers10388183_mottlers
musters94522493_musters
mutter84418883_mutter_
natters73718063_natters
netters73618583_netters
niters64624203_ni_ters
nutters74215423_nutters
omitted10347893omitte_d
otters64021513__otters
painters103013023painters
patters94825193_patters
peripters1368123peripters
permittees1444243permittees
permitter1345963permitter_
petters93722363_petters
philters1398173philters
pitiers93812653_pitiers
platters103415283platters
plotters104011553plotters
pointers103013723pointers
potters94024343_potters
printers103214903printers
putters94219183_putters
quieters17248733quieters
quilters17228433quilters
quitter162910753quitter_
quittors17155413quittors
ratters74422473_ratters
rebutters1195083rebutters
reciters102613113reci_ters
refilters1236103refilters
registers1038883registers
reinters82614773reinters
reletters9138783reletters
remasters11310583remasters
reminders12308653reminders
remittals1144883remittals
remitted113312073remitte_d
remittent1148273remittent
remittor10316553remittor_
resetters9129463resetters
resisters9310453resisters
reutters8138563reutters
rioters73615503_rioters
ritter63822413_ritter_
roisters83615543roisters
rotters74421393_rotters
scatters103612753scatters
scutters103311013scutters
semesters1139113semesters
setters73822063_setters
shatters113313903shatters
shifters14319853shifters
shutters113611333shutters
sifters103714783_sifters
sinters74024073_sinters
sisters73721573_sisters
sitter63323383_sitter_
skirters12337233skirters
skitter113810393skitter_
skittery15315103skittery
slithers114212953slithers
slitter73615873slitter_
slotters84012393slotters
smatter93613333smatter_
smelters103310513smelters
smilers94113843smi_lers
smirkers14316353smirkers
smiter83616413smi_ter_
smites83921923smi_te_s
smithery16325703smithery
smitten936693smitte_n
smothers13349933smothers
snifters11318603snifters
spatters103914703spatters
spitter94015183spitter_
splitters11307323splitters
spotters104313373spotters
sputters104012863sputters
stinters83312743stinters
stutters83210463stutters
submitters1444433submitters
suiters73618873sui_ters
swatters113911793swatters
swifters14277483swifters
swithers144310533swithers
swotters11448473swotters
tatters74520483_tatters
tempters12257293tem_pters
tetters74320473_tetters
tilters73315933_tilters
tinters74221103_tinters
titers64526403_ti_ters
titfers10318933_titfers
tithers104216733_tithers
titter63421163_titter_
totters74618733_totters
trotters83310233trotters
twisters11268173twisters
twitter10278093twitter_
twittery14303893twittery
uniters73814173uni_ters
unmiters1037073unmi_ters
utters63817113__utters
vetters104016313_vetters
vomiters1337203vomi_ters
waisters113811523waisters
waiters104218623wai_ters
wetters103817753_wetters
whetters14246653whetters
whitter139110893whitter_
whittlers1594333whittlers
winters103720473_winters
withers134417753_withers
writers105513493wri_ters
writhers14398983writhers
yatters103914623_yatters
zithers193911973_zithers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623586.33023090.4
3Display Results3583580.1402557.1
 (SQL Overall)1786913586.62626968.2
 
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.