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

169 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
novations1213900(None) 
notations91512971notations
novation111710011novation_
ovations11149261_ovations
conations111318902conations
donations101112352donations
dotations101411632dotations
innovations1445262innovations
iodations1039112iodations
lavations1238972lavations
lobations11219612lobations
locations112512742locations
natations91412492natations
nations74720562n__ations
negations102811962negations
nervations1359482nervations
nidations1039212nidations
nonactions1248372nonactions
notation81414602notation_
notions74014482no__tions
nutations91411762nutations
orations81515802_orations
ovation101510022_ovation_
potations111615072potations
renovations1448422renovations
rogations101510822rogations
rotations91613842rotations
solations9814622solations
solvations1336832solvations
vocations141911422vocations
zonations18139312zonations
ablations11311513ablations
adnations1039753adnations
adorations11310233adorations
aerations9317903aerations
agnations10310033agnations
alations82518893_alations
animations12312193animations
annotations1146883annotations
aviations12311553aviations
avocations15168683avocations
bevatrons1443713bevatrons
bloviations1643753bloviations
cations94524143__cations
citations11312503citations
clavations1546183clavations
coactions1349743coactions
cognations1339593cognations
coitions10312853co_itions
collations12312853collations
conation101420883conation_
connations12312943connations
cooptions13107763cooptions
copatrons1346333copatrons
creations112614543creations
delations102616593delations
denotations1239853denotations
deviations14311163deviations
devotions1356593devotions
dilations102614453dilations
donation91513783donation_
dotation91412733dotation_
durations10311463durations
elations83719123_elations
elevations1338633elevations
enations83316903_enations
enervations1478573enervations
equations1839493equations
evasions1136543_evasions
evocations15259873evocations
fetations12511383fetations
fixations1936353fixations
flotations1366873flotations
foliations1399943foliations
formations1538203formations
gelations102513093gelations
gyrations1336923gyrations
halations12312393halations
himations1438803himations
ideations1039903ideations
illations9311393illations
inflations13310323inflations
innovation1345643innovation_
insolations1149183insolations
intonations1149523intonations
invasions12115413invasions
invocations1647063invocations
iodation9310383iodation_
isolations10310693isolations
kations114013663__kations
lavation1139973lavation_
laxations1637623laxations
legations102711923legations
libations112510443libations
ligations102111993ligations
lobation102110553lobation_
location102113913location_
locutions11207063locutions
lotions74614763lo__tions
lunations9310723lunations
luxations1637273luxations
monitions11310883monitions
motions94215003mo__tions
motivations1647093motivations
mutations111211453mutations
narrations1038943narrations
nasions73112383n__asions
natation81513933natation_
nation64322803n__ation_
natrons73215663n__atrons
navigations1545203navigations
negation92913023negation_
negatons9299273negat_ons
negatrons10275843negatrons
nervation12610243nervation_
nictations1278313nictations
nidation9410583nidation_
nitrations10312033nitrations
nodulations12147003nodulations
nominations13410533nominations
nonaction1149443nonaction_
nonagons947223nona_gons
nonunions945583nonunions
notating92513343notati_ng
notational1048123notational
notion64516583no__tion_
nunnations1095903nunnations
nutation81513103nutation_
oblations1139373oblations
obviations1545463obviations
options93810603_o_ptions
oration71617713_oration_
ovational1246853_ovational
ovulations1337973_ovulations
ozonations1945143ozonations
phonations1538313phonations
portions10514413po_rtions
positions11811503positions
potation101716783potation_
potions93417423po__tions
privations15310103privations
probations14311083probations
pronations12314033pronations
prorations12314463prorations
pupations1338123pupations
quotations19146283quotations
rations74123433__rations
relations92418333relations
renovation1358783renovation_
rogation91612053rogation_
rotation81615453rotation_
salvations1338133salvations
sedations10311253sedations
solation8916153solation_
solutions988883solutions
solvation1237773solvation_
sorptions1137123sorptions
stations82415223_stations
sudations1039903sudations
taxations1636863taxations
tevatrons1244003tevatrons
vacations141910553vacations
venations12311723venations
vexations1937753vexations
violations1337963violations
vocation132311983vocation_
volitions1288663volitions
volutions12108393volutions
zonation171410723zonation_

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 Limit1486411696.26623721.8
3Display Results1691690.0762223.7
 (SQL Overall)1786911696.76526414.0
 
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.