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

133 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
scalations123978(None) 
escalations1347661escalations
scalation11311071scalation_
acylations1547602acylations
alations82518892__alations
dealations11311372dealations
escalation1248872escalation_
halations12312392_halations
osculations1348372osculations
saltations10310622s_altations
salvations1338132s_alvations
scallions1145782scal_lions
solations9814622s_olations
spallations1356102spallations
sublations12410112sublations
ablations11311513_ablations
actuations1239293actuations
acylation1448653acylation_
adulations11310123adulations
alation72920553__alation_
calathos1347523_calatho_s
calutrons1145503_calutrons
captions123813223_ca_ptions
carnations12311353_carnations
caseations1258303_caseations
cassations1276873_cassations
cations94524143_c__ations
caudations13108223_caudations
causations1268143_causations
cautions103313183_ca_utions
chalazions24113323chalazions
chelations1539073chelations
ciliations121111003_ciliations
citations11312503_citations
clarions10310493_c_larions
clavations1546183clavations
coalitions1247923coalitions
collations12312853collations
conations111318903_conations
creations112614543_creations
dealation10313003dealation_
deflations1439713deflations
delations102616593_delations
dilations102614453_dilations
elations83719123__elations
emanations1289593emanations
emulations12310943emulations
epilations12311713epilations
escalating1347093escalati_ng
escalators1245303escalat_ors
evaluations1457323evaluations
exaltations1847293exaltations
excavations2345083excavations
exhalations2146023exhalations
fellations1338063fellations
gelations102513093_gelations
gradations1286863gradations
halation11313853_halation_
illations9311393_illations
inflations13310323inflations
inhalations14126743inhalations
isolations10310693isolations
jactations1936893jactations
lactations1239423lactations
lallations1038743lallations
lavations1238973_lavations
laxations1637623_laxations
maculations1569623maculations
malathions1543873_malathions
natations91412493_natations
oblations1139373_oblations
oscillations1445123oscillations
osculation1249673osculation_
ovulations1337973ovulations
palmations1438733_palmations
palpations1437653_palpations
peculations15310283peculations
placations1438583placations
planations1238723planations
reescalations1573783reescalations
reflations13311233reflations
relations92418333_relations
sabatons1037843s_abat_ons
sacatons1038973s_acat_ons
sacculations1646663sacculations
salacious1147103s_alacious
salivations1448733s_alivations
saltation9312003s_altation_
salutations1147643s_alutations
salvation1239293s_alvation_
sanctions1138873s_anctions
satiations10312113satiations
scalados11276083scala_do_s
scallion1046793scal_lion_
scansions1145323sca_nsions
scarlatina1294053scarlati_na
scarlatinas13102123scarlatinas
scullions1154683scul_lions
sedations10311253s_edations
sensations1059853sensations
separations1369273separations
seriations10316683seriations
serrations10313093serrations
sibilations13127933sibilations
siltations1038553siltations
simulations1368393simulations
sinuations1039413sinuations
situations1038433situations
solation8916153s_olation_
solutions988883s_olutions
solvations1336833solvations
spallation1247023spallation_
speculations1646393speculations
spiculations1646173spiculations
spoliations1347693spoliations
squamations2272743squamations
stagflations1652863stagflations
stagnations1244903stagnations
stallions946073stal_lions
starvations1445053starvations
stations82415223s__tations
striations10312793striations
sublation11311013sublation_
sudations1039903s_udations
sulcations1289583sulcations
sulfations13107813sulfations
summations1456783summations
taxations1636863_taxations
ululations1037143ululations
vacations141910553_vacations
vallations1339093vallations
valuations1348783_valuations
violations1337963violations

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031335.79624258.6
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.28228444.9
 
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.