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

112 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
situations103843(None) 
sinuations1039411sinuations
situation949421situation_
actuations1239292actuations
citations11312502cit_ations
liquations1945622liquations
nitrations10312032nitrations
satiations10312112satiations
saturations1148572saturations
siltations1038552siltations
simulations1368392simulations
sinuation9310412sinuation_
situating1038882situati_ng
situational1144582situational
stations82415222s_t_ations
titrations1039172titrations
vitiations1338742vitiations
actuation11310333actuation_
agitations11310063agit_ations
arcuations1249343arcuations
ciliations121111003ciliations
citation10314363cit_ation_
dictations1389703dictations
dilations102614453di_lations
dilutions10248583dilu_tions
dotations101411633dot_ations
equations1839493_equations
estimations1349943estimations
estivations1449273estivations
fetations12511383fet_ations
figurations1545083figurations
filiations13119093filiations
filtrations1445623filtrations
fixations1936353fi_xations
guttations1145593guttations
habituations1743113habituations
hesitations1448543hesit_ations
himations1438803hi_mations
ideations1039903_ideations
illations9311393_illations
imitations1259963imit_ations
initiations11410723initiations
insinuations12136423insinuations
intubations1346833intubations
intuitions1047293intuitions
iodations1039113_iodations
isolations10310693isolations
iterations10413823_iterations
libations112510443li_bations
librations12149063librations
ligations102111993li_gations
lineations1039543lineations
liquation1846553liquation_
literations11610583literations
litigations1247333litigations
maturations1348443maturations
migrations13168683migrations
mitigations1447623mitigations
mutations111211453mut_ations
natations91412493nat_ations
nictations1278313nictations
nidations1039213ni_dations
nitration9313443nitration_
notations91512973not_ations
nutations91411763nut_ations
obturations13116423obturations
pinnations1236883pinnations
potations111615073pot_ations
rotations91613843rot_ations
saltations10310623saltations
salutations1147643salutations
salvations1338133salvations
sanitations11410843sanit_ations
satiation9313433satiation_
saturation1049803saturation_
scalations1239783scalations
sedations10311253s_edations
seductions1366873seductions
sensations1059853sensations
seriations10316683seriations
serrations10313093serrations
sibilations13127933sibilations
siltation939213siltation_
simulation1269583simulation_
sinuating1039683sinuati_ng
situates8310373situat__es
solations9814623s_olations
solutions988883solu_tions
solvations1336833solvations
spiculations1646173spiculations
statins73719773s_t_ati_ns
station72717243s_t_ation_
stictions1148353s_tictions
stimulations1456203stimulations
stipulations1455443stipulations
striations10312793striations
suasions838783s__uasions
sublations12410113sublations
suctions103012903s__uctions
sudations1039903s_udations
sulcations1289583sulcations
sulfations13107813sulfations
summations1456783summations
titivations1446263titivations
titration9310543titration_
triturations1245683triturations
tuitions838283__tuitions
valuations1348783valuations
vibrations15157373vibrations
violations1337963violations
visitations1447673visit_ations
vitiation1239563vitiation_

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.406440125.6
2DLD Change Limit1406031125.73324525.2
3Display Results1121120.0631777.8
 (SQL Overall)1786911126.20228811.8
 
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.