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 “eluviation” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

53 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
eluviation137661(None) 
eluviations14115791eluviations
exuviation20116341exuviation
bloviation1544002bloviation
elevation1239232elev_ation
elucidation1445012elucidation
elutriation1146712elutriation
eluviating1444892eluviating
exuviations2195692exuviations
illuviation1453572illuviation
alleviation1454653alleviation
aviation11312743__aviation
bloviations1643753bloviations
clavation1447003clav_ation
deviation13312393_deviation
education12310203edu_cation
elation73620453el___ation
elevations1338633elev_ations
elicitation1347533elicitation
elimination1348533elimination
elongation1145353elongation
elucidations1544513elucidations
elution72913823elu___tion
elutriations1246023elutriations
eluviate1146953eluviat__e
eluviated1345333eluviat_ed
eluviates1246103eluviat_es
emaciation1449283emaciation
emulation11312393emu_lation
enunciation1345463enunciation
equation17310483equ__ation
equitation1948343equitation
eructation1248333eructation
erudition1046173erudi_tion
estivation1349813estivation
eviction13228683e__viction
expiation18710423e_xpiation
exudation1787693exu_dation
exultation1747533exultation
exuviating2144523exuviating
floriation1367793floriation
fluviatile1651503fluviatile
glaciation1346583glaciation
illuviations1553053illuviations
lavation1139973_lav_ation
levigation1447023_levigation
levitation1349443_levitation
lunation8311923_lu_nation
luxation1538233_lu_xation
obviation1446093_obviation
reluctation1347963reluctation
repudiation14107603repudiation
ululation938093ulu_lation

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.423422437.4
2DLD Change Limit140603536.28022389.0
3Display Results53530.0331606.1
 (SQL Overall)178691536.73626527.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.