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

183 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
betatter103545(None) 
betatters1134961betatters
batter84928872b__atter
beater84729392be_a_ter
begetter11136312begetter
besetter10137972besetter
bespatter1343142bespatter
betattered1343142betattered
better84723702be__tter
blatter94415652b_latter
tatter64024572__tatter
abetter958323abe__tter
baiter84422553b__aiter
banter84825333b__anter
barter85525373b__arter
baster85333593b__aster
bather115322513b__ather
batted95623653b__atted
batten85217123b__atten
batters94626013b__atters
battery124911813b__attery
battier93515713bat_tier
battler94113383bat_tler
beader94623793be_a_der
beadier103513913be_adier
beaker125520693be_a_ker
beakier134012163be_akier
beamier113411943be_amier
bearer85323913be_a_rer
beaten84617063be_a_ten
beaters94925043be_a_ters
beaver114819253be_a_ver
bedotted1234983bedotted
bedwetter1542663bedwetter
beetler938033be_etler
befitted14305723befitted
begetters12135043begetters
begotten1143243begotten
behaver15206723beha_ver
belated103520013bela_ted
belayer12339503bela_yer
belittler1142493belittler
belter84720963be__lter
berate84729023bera_te_
berated104422133bera_ted
berates94126873bera_tes
besetters11136633besetters
besotted1135843besotted
bespatters1442783bespatters
betaine9413783betaine_
betaines10313293betaines
betake124512703beta_ke_
betaken13438283beta_ken
betakes134212523beta_kes
betatron1045223betatron
betattering1444143betattering
betaxed17307023beta_xed
betrayer1345643betrayer
betted94721163be__tted
betters94422093be__tters
bettor83612223be__ttor
bewailer1334863bewailer
bitter84622673b__itter
bittier94211663bit_tier
blaster94017303b_laster
blather125314203b_lather
blatted104812713b_latted
blatters104414093b_latters
bleater94515303blea_ter
bloater94013423bloa_ter
blotter94612853b_lotter
boaster94616433b_oaster
boater84622093b_oa_ter
bottler94211883bot_tler
brattier1047663brattier
breather133610593breather
butter84724233b__utter
chatter124416643_chatter
clatter94014973_clatter
cytaster1383863cytaster
debater104114693deba_ter
decanter112510793decanter
defatted1335673defatted
deratted1048403deratted
desalter938363desalter
detacher1437543detacher
detailer9268673detailer
detainer92910793detainer
detecter11298733detecter
detester9239683detester
dewater112912423dewa_ter
easter65027983_e_aster
eater54639843_e_a_ter
elater64724203_ela_ter
emitter93211083_emitter
exacter1637403_exacter
exalter1437563_exalter
fatter94523213__fatter
feaster10812983fe_aster
feater95224053fe_a_ter
feather133613503fe_ather
fetter94120383fe__tter
flatter103815963_flatter
getter74117613ge__tter
hatter94724873__hatter
heater94828303he_a_ter
heather133914853he_ather
jettier14358693jet_tier
latter65027893__latter
leather103815783le_ather
letter63722583le__tter
levanter1145303levanter
matter84325343__matter
meatier93214613me_atier
metamer1139613meta_mer
metate82720533meta_te_
metates92720013meta_tes
natter64420743__natter
neater64424313ne_a_ter
negater83711963nega_ter
netter63722023ne__tter
nettier74211813net_tier
nettler7349503net_tler
patter84628263__patter
pearter9412743pe_arter
peatier94017233pe_atier
petter83924773pe__tter
pettier94213613pet_tier
phatter123810203_phatter
platter93917413_platter
poetaster1145673poetaster
ratter64326313__ratter
realter73716313re_alter
rebater93517913reba_ter
rebutter10106273rebutter
recanter101913153recanter
regather1236733regather
relater73723143rela_ter
reletter81311023reletter
remaster10311473remaster
remitter102810323remitter
repattern1143663repattern
resetter81511833resetter
retailer82911573retailer
retainer82913813retainer
retaker113714313reta_ker
retarder9229433retarder
retaste72313133retaste_
retasted92412113retasted
retastes82212903retastes
retorter8410733retorter
reutter71010093re_utter
scatter93815173_scatter
seater64534153se_a_ter
sedater83713623seda_ter
setter64023723se__tter
settler73410653set_tler
shatter103615703_shatter
smatter93613333_smatter
spatter94016523_spatter
splatter10348883splatter
squatter1735913squatter
starter73817883_starter
stater64427563_sta_ter
stutter72911463_stutter
swatter104113323_swatter
tarter64023563__tarter
taster64930573__taster
tater54138613__ta_ter
tatted74920533__tatted
tatters74520483__tatters
tattier74216243__tattier
tattler73112213__tattler
tauter64318023__tauter
teataster944563teataster
tetter64322453__tetter
titter63421163__titter
totter65021463__totter
vetter93417643ve__tter
watter93221983__watter
weather133513223we_ather
wetter93919443we__tter
yatter94116213__yatter

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 Limit1461621836.61022112.3
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.82926166.5
 
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.