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

132 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
elevation123923(None) 
elevations1338631elevations
clavation1447002clavation
delegation1238882delegation
elation73620452el__ation
election102015352ele_ction
elevating1338202elevating
elevator1146722elevat_or
eluviation1376612eluviation
enervation1369472enervation
lavation1139972_lavation
legation92412932_legation
relegation11610022relegation
aeration8319933_aeration
alation72920553al__ation
alienation1048793alienation
allegation1146813allegation
alleviation1454673alleviation
alteration10612903alteration
bevatron1343893_bevatron
bloviation1544013bloviation
celebration1546463celebration
chelation1439973chelation
clavations1546183clavations
creation102816513cre_ation
cremation13511643cremation
crenation11412923crenation
deaeration11313013deaeration
defecation1679803defecation
delation92318083_delation
delectation1448553delectation
delegations1348033delegations
deletion92011973dele__tion
denegation1249413denegation
denervation1567943denervation
derivation14712783derivation
deviation13312403_deviation
devotion1256763_devotion
education12310203education
egestion946863ege_stion
ejection172510043eje_ction
elations83719123el__ations
elections112414973ele_ctions
electron102611413ele_ctron
elevate101110373elevat__e
elevated12118293elevat_ed
elevateds13122883elevateds
elevates111110433elevat_es
elevators1246313elevators
elevon977953elev___on
elocution1145673elocution
elongation1145353elongation
elution72913823el__ution
eluviations14115793eluviations
emanation11910783emanation
emendation1346553emendation
emulation11312393emulation
enation73419233__enation
enervations1478573enervations
epilation11312963epilation
equation17310483e_quation
erection102115513ere_ction
estivation1349813estivation
evasion1036753__evasion
evection131910833eve_ction
evocation142010293evocation
excavation2245433excavation
execration1949833execration
execution1846303execution
exemption2064943exemption
exertion15310083exe_rtion
expiation18710423expiation
exudation1787693exudation
exuviation20116343exuviation
federation1449573federation
fellation1238843fel_lation
fetation11613143_fetation
flection13239563fle_ction
flotation1267813flotation
gelation93014433_gelation
generation11312433generation
gleization20115783gleization
hebetation1557093hebetation
ideation9310493ide_ation
illation8311943il_lation
iteration9515033iteration
lavations1238973_lavations
laxation1538423_laxation
lection92614863_le_ction
legations102711923_legations
lenition8310083_lenition
levator10298973_levat_or
levigation1447023_levigation
levitation1349443_levitation
libation102411363_libation
ligation92313093_ligation
lobation102110553_lobation
location102113913_location
lunation8311923_lunation
luxation1538233_luxation
negation92913023_negation
nervation12610243nervation
novation111710013_novation
operation11314003operation
ovation101510023__ovation
peltation11312963pel_tation
placation1339773placation
planation11310123planation
plication13311683plication
predation12313463predation
privation14311173privation
relation82619773_relation
relaxation1746453relaxation
relegations1248973relegations
relocation12312113relocation
renovation1358783renovation
reservation1489143reservation
revelation13410923revelation
salivation1349813salivation
salvation1239293salvation
sedation9312453_sedation
selection11311273sele_ction
solvation1237773solvation
television1352463television
tevatron1143973_tevatron
toleration1048963toleration
ulceration1247263ulceration
ululation938093ululation
vegetation1448213vegetation
venation11513503_venation
veneration13412343veneration
vexation1838783_vexation

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 Limit1486411326.36023371.2
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.82926166.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.