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

242 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
ablaut831326(None) 
ablauts936081ablauts
abaft10318062ab_aft
ablate82219212ablate
ablaze17239832ablaze
ablest84721832ablest
about75229082ab_out
abut66834952ab__ut
abwatt11410672abwatt
alant55742292a_lant
aslant6317752aslant
beaut75135212_beaut
blast76532572_blast
blat66550952_bla_t
oblast8613662oblast
umlaut838032umlaut
aba512850953ab_a__
abaca95118043ab_aca
abaci94718843ab_aci
aback134816173ab_ack
abacus10349763abacus
abaka114313823ab_aka
abamp11310603ab_amp
abas68642083ab_a_s
abase76023483ab_ase
abash106016513ab_ash
abate76627843ab_ate
abaya104413173ab_aya
abba810522653abba__
abbacy1536623abbacy
abbas95918643abba_s
abbot9318453ab_bot
abduct11108543abduct
abeam9316533abea_m
abet610547943ab__et
abeyant1248083abeyant
abject17137703abject
ablated102513443ablated
ablates92416903ablates
ablator939843ablator
able66340533abl__e
abled86926833abl_ed
ableist9311773ableist
abler75624313abl_er
ables75935543abl_es
ablins8316193ablins
abloom1039783abloom
abluent939623abluent
ablush1147223ablush
abluted10188363abl_uted
ably99725133abl__y
aboard9312613aboard
abort76133583ab_ort
abrade9313053abrade
abreact11310823abreact
abreast9311273abreast
abrupt1039943abrupt
absent84016993absent
abuts75417073ab__uts
abvolt11169833abvolt
abwatts1233403abwatts
adapt81218553a_dapt
aflame1138723aflame
afloat9315153afloat
aghast105711373aghast
aglare7312423aglare
aglet65534143agl_et
ala312463603a_la__
alack114820063a_lack
alae45643753a_la_e
alamo7418143a_lamo
alan46844083a_la_n
aland65526413a_land
alane56135613a_lane
alang66023513a_lang
alans55636173a_lans
alants67722023a_lants
alar46340073a_la_r
alarm76621423a_larm
alarum85411983a_larum
alary86123443a_lary
alas46358123a_la_s
alate55340323a_late
alba68328333alba__
albas75925393alba_s
albata839333albata
albeit8314343albeit
album92312653a_lbum
alert54740653a_lert
algum82711763a_lgum
alist56136783a_list
alit46155693a_l_it
allay85620393alla_y
allays94313743allays
allium8311243allium
allot54933873a_llot
almud84012183a_lmud
almug8429303a_lmug
aloft8423433a_loft
aloud65018073a_loud
alt36467963a_l__t
alum65227613a_l_um
ambulant1247163ambulant
anlace82513923anlace
anlage72514233anlage
anlas55626933anla_s
apart74330673a_part
applaud1293903applaud
arhat8327093arha_t
arrant6623253arrant
askant10412713askant
assault747413assault
atlas55821583atla_s
atlatl637873atlatl
avant86224663a_vant
avast85519363a_vast
avaunt959603a_vaunt
await85524493a_wait
baht96740013_b_aht
bailout9414133bailout
bait66556003_b_ait
balas76937213bala_s
balata8614673balata
ballast9313993ballast
ballet84733973ballet
ballot84624093ballot
ballute938543ballute
barbut104617003barbut
basalt83519583basalt
bast66362413_b_ast
bat510988953_b_a_t
batt65053873_b_att
baud74928423_b_aud
beast76338643_beast
beat66168303_bea_t
beau66137273_beau_
beaus75127113_beaus
beauts86015283_beauts
beauty115410163_beauty
beaux146513213_beaux
belaud939133belaud
bhut95425713_b_hut
blab86629133_bla_b
blabs95619633_blabs
black134719073_black
blade85923333_blade
blae66134643_bla_e
blaff135216483_blaff
blah98625063_bla_h
blahs105616513_blahs
blain75421793_blain
blam86131703_bla_m
blame95625493_blame
blams95023853_blams
bland85320453_bland
blank115418553_blank
blare75826233_blare
blase75524233_blase
blasts85116773_blasts
blasty115611053_blasty
blate75933783_blate
blats75132503_blats
blaw97026723_bla_w
blawn106813703_blawn
blaws105620463_blaws
blaze165520833_blaze
bleat75737003_bleat
blent76230953_blent
blest76431723_blest
blet66247673_bl_et
bloat75229923_bloat
blot65842323_bl_ot
blub85324873_bl_ub
blue65328463_bl_ue
bluet75631193_bluet
blunt75525023_blunt
blur66020533_bl_ur
blurt77625623_blurt
boart78835933_boart
boast75935703_boast
boat66360313_boa_t
bout66353293_b_out
bract96332723_bract
brant74742173_brant
brat66055543_bra_t
brut66537963_b_rut
but55963023_b__ut
butut75522913_butut
cablet104429463cabl_et
callant94121223callant
clapt98027173_clapt
clast76030583_clast
clout75330463_clout
daut56443563__daut
eclat7523603ecla_t
fabliau1244903fabliau_
fabliaux2041253fabliaux
fallout10313503fallout
flat77147823_fla_t
flaunt9712913_flaunt
flauta937823_flauta
flout86226203_flout
gabbart1248883gabbart
gallant83517113gallant
gallnut847253gallnut
gelant72821673gelant
ghaut95919433_ghaut
glout65925813_glout
glut56331293_gl_ut
haut75949733__haut
kraut95221403_kraut
last46260323__last
lat37593403__la_t
latu47934183__latu
laud56527723__laud
lout45952143__lout
maut65448453__maut
oblasti945953oblasti
oblasts947303oblasts
oblate82214743oblate
pablum1237503pabl_um
pilau73618523pilau_
pilaus84114133pilaus
plait75631573_plait
plant75437113_plant
plat66048873_pla_t
rabat72832223rab_a_t
sabbat10314713sabba_t
slant55238703_slant
slat46959023_sla_t
slut45040593_sl_ut
splat76129343spla_t
tabla73318363tabla__
tablas83716163tabla_s
tableau966283tableau_
tableaus1054853tableaus
tableaux1772863tableaux
tablet84227643tabl_et
taut47048963__taut
umlauts943193umlauts
volant9316323volant
walnut939433walnut

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162425.42320784.8
3Display Results2422420.0763184.2
 (SQL Overall)1786912425.87230431.0
 
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.