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

119 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
sabaton93771(None) 
sabatons1037841sabatons
sabayon1244231sabayon
sacaton938991sacaton
abator84512712_abator
baton75822422__baton
rabato83413262rabato_
rabatos93010902rabatos
sabayons1343962sabayons
sacatons1038972sacatons
subatom1147052subatom
zacaton1845632zacaton
abalone938903_abalone
abandon1045463_abandon
abate76627843_abat_e
abated95918453_abated
abater85518123_abater
abates85825033_abates
abating10413973_abating
abatis84317933_abatis
abators94413083_abators
ablation10312433_ablation
ablator939843_ablator
aboon74918703_ab_oon
alation72920553_alation
amatol838693_amatol
amazon1736833_amazon
baboon103613913bab_oon
bacon95620593__bacon
baron78131243__baron
baryton1246003baryton
batons85519423__batons
beton76022063__beton
cabezon2044663cabezon
canton85722993ca_nton
carton84522663ca_rton
craton84517193_craton
dalapon1044893dalapon
dalton7311273da_lton
gabion93211033gab_ion
gaboon93211773gab_oon
gigaton946343gigaton
habitan1236903habitan
halation11313853halation
lavation1139973lavation
laxation1538423laxation
libation102411363libation
lobation102110553lobation
marathon1346813marathon
megaton10269853megaton
natation81513933natation
negaton8299143negaton
paragon10311023paragon
parton84720993pa_rton
rabat72832223rabat__
rabats83116223rabat_s
ratton64116123ra_tton
rebato83714683rebato_
rebatos92913113rebatos
rubato8319683rubato_
rubatos9278653rubatos
sabal75422483saba__l
sabals84618863saba_ls
sabbat10314713sabbat__
sabbath1445393sabbat_h
sabbaths1543973sabbaths
sabbatic1445323sabbatic
sabbats1138633sabbat_s
sabin74924953sab__in
sabot7931783sab__ot
sabots8314703sabot_s
sadiron836043sadiron
saffron1344173saffron
sagaman10117563sagaman
sagamen10127503sagamen
salmon84614183sa_lmon
salon55228553s__alon
saloon64418023sa_loon
saltation9312003saltation
salvation1239293salvation
sanction1049533sanction
santo56227283sa_nto_
santol64515243sa_ntol
santos64421833sa_ntos
sapajou1643693sapajou
saran53730303sara__n
sartor6313883sa_rtor
saskatoon1341853saskatoon
satiation9313433satiation
satin55935223s__atin
savarin10310003savarin
savate9313783savat_e
savates10312953savates
scalation11311073scalation
season62714903s_eason
sedation9312453sedation
senator7313073senator
seton55223543s__eton
sexton133610793s_exton
shabbatot1652513shabbatot
skatol1035723s_katol
solation8916153solation
soliton7410233soliton
statin63921473s_tatin
station72717243s_tation
stator64015483s_tator
subatoms1245883subatoms
subito8410453subito_
sublation11311013sublation
subtaxon1742743subtaxon
subtone9310343sub_tone
sudation9310803sudation
synanon1044743synanon
taxation1537993taxation
vacation131911893vacation
wanton94413813wa_nton
zabaione1942793zabaione
zabajone2642053zabajone
zacatons1945703zacatons

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.390458182.1
2DLD Change Limit1340271196.09321996.9
3Display Results1191190.0333606.1
 (SQL Overall)1786911196.51627423.4
 
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.