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

197 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
ablauts93608(None) 
ablaut8313261ablaut_
ablate82219212abla_te
ablates92416912ablates
abuts75417072ab__uts
abwatts1233412abwatts
alants67722022a_lants
beauts86015282_beauts
blasts85116772_blasts
blats75132502_bla_ts
oblasts947302oblasts
umlauts943192umlauts
abacas104414723ab_acas
abacus10349763ab_acus
abaft10318063ab_aft_
abakas123911743ab_akas
abamps1236253ab_amps
abas68642083ab_a__s
abases85720773ab_ases
abate76627843ab_a_te
abates85825043ab_ates
abatis84317943ab_atis
abattis9297823ab_attis
abayas114011703ab_ayas
abbas95918653abba__s
abbots1039293ab_bots
abducts1265313abducts
abets75621683ab__ets
ablated102513443ablated
ablator939863ablator
ablators1069893ablators
ablaze17239833abla_ze
ableist9311783ableist
ableists1036563ableists
ables75935543abl__es
ablest84721833ablest_
ablings1038743ablings
ablins8316193abl_ins
abluents1045483abluents
ablush1147223abl_ush
abluted10188363abl_uted
aborts84916193ab_orts
abortus9397923abortus
about75229083ab_out_
abrades10312083abrades
abreacts1245653abreacts
absents93510733absents
abut66834953ab__ut_
abvolts12104383abvolts
abwatt11410673abwa_tt
adapts9107813a_dapts
afflatus1442683afflatus
aglets73915683agl_ets
alamos8415003a_lamos
alands75418373a_lands
alans55636173a_la_ns
alant55742293a_lant_
alarms85913053a_larms
alarums9408923a_larums
alas46358123a_la__s
alate55340333a_la_te
alates64833973a_lates
albas75925393alba__s
albata839333alba_ta
albatas938383albatas
albums10198273a_lbums
alerts64418223a_lerts
algums9208043a_lgums
allays94313743alla_ys
alliums957973alliums
allots64019173a_llots
almuds9378773a_lmuds
almugs9396423a_lmugs
alts46639903a_l__ts
alums75720603a_l_ums
anlaces92313733anlaces
anlages82414113anlages
anlas55626933anla__s
anlases72514903anlases
applauds13103283applauds
arhats9312983arha_ts
aslant6317753aslant_
assaults843863assaults
atlantes838553atlantes
atlas55821583atla__s
atlases72410643atlases
atlatl637873atla_tl
atlatls744773atlatls
awaits96411953a_waits
bahts105617803_b_ahts
bailouts1036613bailouts
baits76630583_b_aits
balas76937213bala__s
balases93815433balases
balata8614683bala_ta
balatas9311833balatas
ballasts1037933ballasts
ballets93719513ballets
ballots94116033ballots
ballute938543ballute
ballutes1037523ballutes
barbuts11439843barbuts
basalts9358963basalts
basts75936933_b_asts
bats66962333_b_a_ts
batts76727563_b_atts
bauds85821043_b_auds
beasts84519723_beasts
beats76042253_bea_ts
beaus75127113_beau_s
beaut75135213_beaut_
beauty115410163_beauty
belauds1036643belauds
bhuts105812953_b_huts
blabs95619633_bla_bs
blacks144914953_blacks
blades95221253_blades
blaffs14426623_blaffs
blahs105616513_bla_hs
blains84516373_blains
blames105121863_blames
blams95023853_bla_ms
blanks124112893_blanks
blares85021633_blares
blast76532573_blast_
blasty115611053_blasty
blat66550953_bla_t_
blate75933783_bla_te
blaws105620463_bla_ws
blazes174817353_blazes
bleats85518623_bleats
blets75324943_bl_ets
bloats85215763_bloats
blots75626173_bl_ots
blubs95818153_bl_ubs
blues75127043_bl_ues
bluets87215493_bluets
blunts84512893_blunts
blurs74619083_bl_urs
blurts84412643_blurts
boarts84716873_boarts
boasts85017923_boasts
boats75635153_boa_ts
bouts75131313_b_outs
bracts105617773_bracts
brants85723053_brants
brats75336023_bra_ts
bruts75922953_b_ruts
buts67247693_b__uts
bututs8409423_bututs
cablets114216343cabl_ets
callants104112143callants
clasts84817293_clasts
clouts87017203_clouts
dauts67822243__dauts
eclats8313033ecla_ts
fallouts1137883fallouts
flats86429743_fla_ts
flatus94310783_flatus
flaunts1056133_flaunts
flauta937823_flauta
flautas1036153_flautas
flouts94315273_flouts
gabbarts1344063gabbarts
gallants93310373gallants
gallnuts943923gallnuts
gelants82611443gelants
ghauts10447783_ghauts
glouts74414713_glouts
gluts66120133_gl_uts
krauts10418513_krauts
lasts57731263__lasts
lats45962703__la_ts
lauds65618483__lauds
louts56330273__louts
mauts75927193__mauts
oblast8613663oblast_
oblasti945953oblasti
oblate82214743obla_te
oblates91913243oblates
pablums1345123pabl_ums
pilaus84114133pilau_s
plaits83816473_plaits
plants84921803_plants
plats75531373_pla_ts
rabats83116223rab_a_ts
sabbats1138643sabba_ts
slants64819083_slants
slats55436903_sla_ts
sluts54523983_sl_uts
splats84817303spla_ts
tablas83716163tabla__s
tableaus1054853tableau_s
tablets94714383tabl_ets
tauts56125513__tauts
umlaut838033umlaut_
walnuts1033843walnuts

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271976.21621561.6
3Display Results1971970.0802462.5
 (SQL Overall)1786911976.74926476.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.