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

172 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
nidations103921(None) 
nidation9410581nidation_
animations12312192animations
citations11312502citations
dilations102614452dilations
fixations1936352fixations
himations1438802himations
ideations1039902_ideations
iodations1039112iodations
libations112510442libations
ligations102111992ligations
natations91412492natations
nations74720562n__ations
negations102811962negations
nictations1278312nictations
nidating1039782nidati_ng
nitrations10312032nitrations
notations91512972notations
novations12139002novations
nutations91411762nutations
oxidations1845442oxidations
sedations10311252sedations
sudations1039902sudations
ablations11311513ablations
adaptions1245223_adaptions
additions1186333additions
adnations1039753adnations
aerations9317903aerations
agitations11310063agitations
agnations10310033agnations
alations82518893_alations
animation11313683animation_
auditions1078753auditions
aviations12311553aviations
cations94524143__cations
caudations13108223caudations
ciliations121111003ciliations
citation10314363citation_
cnidarians1353663cnidarians
conations111318903conations
creations112614543creations
delations102616593delations
denudations1346343denudations
diatrons939613di_atrons
dictations1389703dictations
dictions111812673di_ctions
dilation92215463dilation_
dilutions10248583dilutions
donations101112353donations
dotations101411633dotations
durations10311463durations
editions9310403_editions
elations83719123_elations
enations83316903_enations
epilations12311713epilations
equations1839493equations
exudations18107073exudations
fetations12511383fetations
fictions132410743fi_ctions
filiations13119093filiations
fixation1837073fixation_
gelations102513093gelations
gigatons1046053gigat_ons
gradations1286863gradations
gyrations1336923gyrations
halations12312393halations
himation1339753himation_
hydrations1745283hydrations
ideation9310493_ideation_
illations9311393illations
imitations1259963imitations
inactions1139323inactions
incautions1245973incautions
incitations13310883incitations
indagations1345403indagations
indamins1147603indami_ns
indentions1149063indentions
indexations1946023indexations
indications14310973indications
indictions1339313indictions
inductions1348803inductions
indurations1249583indurations
infixations2146693infixations
inflations13310323inflations
initiations11410723initiations
intimations13411883intimations
inundations12125533inundations
invasions12115413invasions
invitations1449053invitations
iodation9310383iodation_
ionizations2049893ionizations
isatins7310773_isati_ns
kations114013663__kations
laudations1146843laudations
lavations1238973lavations
laxations1637623laxations
legations102711923legations
libation102411363libation_
librations12149063librations
ligation92313093ligation_
lineations1039543lineations
liquations1945623liquations
lobations11219613lobations
locations112512743locations
lunations9310723lunations
luxations1637273luxations
mediations13310983mediations
migrations13168683migrations
mutations111211453mutations
narrations1038943narrations
nasions73112383n__asions
natation81513933natation_
nation64322803n__ation_
natrons73215663n__atrons
navigations1545203navigations
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
nervations1359483nervations
niacins938543ni_aci_ns
nicotins1058173nicoti_ns
nictation1189273nictation_
nidates8311893nidat__es
nitons64614903ni__t_ons
nitration9313443nitration_
nodulations12147003nodulations
nominations13410533nominations
nonactions1248373nonactions
notation81414603notation_
notions74014483n__otions
novation111710013novation_
nunnations1095903nunnations
nutation81513103nutation_
oblations1139373oblations
orations81515803_orations
ovations11149263_ovations
oxidation1746323oxidation_
pinnations1236883pinnations
plications14310493plications
potations111615073potations
predations13812153predations
privations15310103privations
pupations1338123pupations
radiations11311923radiations
rations74123433__rations
redactions1359133redactions
relations92418333relations
rogations101510823rogations
rotations91613843rotations
ruinations1039603ruinations
sanitations11410843sanitations
sedation9312453sedation_
seditions1039013seditions
siltations1038553siltations
sinuations1039413sinuations
situations1038433situations
solations9814623solations
sonications1349953sonications
stations82415223_stations
sudation9310803sudation_
taxations1636863taxations
titrations1039173titrations
urinations10310693urinations
vacations141910553vacations
validations1547243validations
venations12311723venations
vexations1937753vexations
vibrations15157373vibrations
violations1337963violations
vitiations1338743vitiations
vocations141911423vocations
zonations18139313zonations

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411726.25023782.6
3Display Results1721720.0762263.2
 (SQL Overall)1786911726.74926476.7
 
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.