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

115 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
sinuation931041(None) 
sinuations1039411sinuations
situation949421situation
insinuation11137262insinuation
lineation9310762lineation
liquation1846552liquation
pinnation1138012pinnation
sensation9510582sensation
siltation939212siltation
simulation1269582simulation
sinuating1039682sinuating
situations1038432situations
actuation11310333actuation
adnation9310783adn_ation
agnation9311723agn_ation
animation11313683animation
annulation1068953annulation
arcuation11410583arcuation
ciliation111112493ciliation
citation10314363ci_tation
conation101420883con_ation
connation11314263connation
dentation10315243dentation
denudation1247303denudation
dictation12810563dictation
dilation92215463di_lation
dilution9239143dilu_tion
donation91513783don_ation
enation73419233_en_ation
equation17310483_equation
figuration1445913figuration
filiation121110243filiation
fixation1837073fi_xation
himation1339753hi_mation
ideation9310493_ideation
illation8311943_illation
inaction1039623_inaction
incaution1146583_incaution
incubation1448363_incubation
induction1248983_induction
induration11410613_induration
inflation12311093_inflation
inhumation1567053_inhumation
insinuations12136423insinuations
insulation10311663_insulation
intubation1247773_intubation
intuition947623_intuition
inunction1146893_inunction
inundation11116173_inundation
invasion11115473_invasion
iodation9310383_iodation
isolation9311643isolation
libation102411363li_bation
libration111510163libration
ligation92313093li_gation
lineations1039543lineations
liquations1945623liquations
lunation8311923lun_ation
mentation11313983mentation
migration12179703migration
nation64322803__n_ation
nictation1189273nictation
nidation9410583ni_dation
nitration9313443nitration
nunnation9126563nunnation
nutation81513103__nutation
pinnations1236883pinnations
ruination9311273ruin_ation
saltation9312003saltation
salutation1048903salutation
salvation1239293salvation
sanction1049533san_ction
sanitation10412043sanitation
satiation9313433satiation
saturation1049803saturation
scalation11311073scalation
sedation9312453s_edation
seduction1266983seduction
sensations1059853sensations
seriation9318063seriation
serration9414063serration
sibilation12128773sibilation
siltations1038553siltations
simulations1368393simulations
sinuate7412163sinuat__e
sinuated938413sinuat_ed
sinuately1243703sinuately
sinuates8310963sinuat_es
situating1038883situating
situational1144583situational
solation8916153s_olation
solution889593solu_tion
solvation1237773solvation
sonication12411183sonication
spiculation1547033spiculation
station72717243s__tation
stimulation1377223stimulation
stipulation1356333stipulation
striation9313483striation
suasion739363s__uasion
sublation11311013sublation
suction93713043s__uction
sudation9310803s_udation
sulcation11710733sulcation
sulfation1288783sulfation
summation1347803summation
supination1249883supin_ation
titration9310543titration
urination9312173urin_ation
valuation1249973valuation
venation11513503ven_ation
vibration14138203vibration
violation1238443violation
vitiation1239563vitiation
zonation171410723zon_ation

Search took 8 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 Limit1486411157.01621186.0
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.48523873.2
 
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.