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

107 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
elusive105700(None) 
delusive1245841delusive
abusive1245282abusive
allusive1144782allusive
amusive1246252amusive
effusive1743262effusive
elative10312452elative
elusion72310952elusion
elusively1544222elusively
emulsive1344532emulsive
erosive1039192erosive
evasive1344662evasive
exclusive2144422exclusive
illusive1144532illusive
plausive1344582plausive
plosive1236672plosive
prelusive1455582prelusive
reclusive1475432reclusive
seclusive1463752seclusive
alive85722513al__ive
alsike1047913al_sike
alumine9412693alumine
alunite7311633alunite
belive115415303bel__ive
cerusite1047763cerusite
collusive1444933collusive
cursive1237833cursive
decisive1446633decisive
delusion937433delusion
delusively1753823delusively
derisive1247503derisive
dilutive1255373dilutive
eductive1476863eductive
egestive1246833egestive
elapine9310673elapine
elatives1139783elatives
elective13311003elective
elegise8139393elegise
elegize17127383elegize
elflike1435133elflike
elide64922643el__ide
elision72311103elision
elite56230183el__ite
else45923083el_s__e
eluate62315433elu_ate
elude64517623elu__de
eluding93412113eluding
elusions82610083elusions
elusory1083993elusory
elute54822573elu__te
eluting84115293eluting
elution72913823elution
eluvia936133eluvi_a
eluvial1045853eluvial
eluviate1146953eluviate
eluvium1244973eluvium
elysian1065083elysian
emissive1345923emissive
emotive1239193emotive
endive103310473e_ndive
ensile62616473e_nsile
eosine64519413e_osine
equine151711573equ_ine
erudite838483erudite
eruptive1345793eruptive
exclusives2243323exclusives
excursive2143933excursive
explosive2144833explosive
expulsive2143903expulsive
extrusive1944803extrusive
exuviae1744343exuviae
felsite1039083fel_site
fusile94313493_fusile
glaive10357933gl_aive
inclusive1445323inclusive
infusive1445173infusive
jussive1734293jussive
leucine938073leucine
leucite937753leucite
live76540993_l__ive
lucite8313343_lucite
lupine84013533_lupine
lustre64011683_lustre
lysine94210553_lysine
massive12289773massive
missive122413143missive
occlusive1643263occlusive
olive84817153ol__ive
passive12239593passive
pensive122610393pensive
perfusive1744343perfusive
plosives1335893plosives
preclusive1753883preclusive
recursive1445453recursive
relative11313143relative
relive95120783rel__ive
relumine1038933relumine
repulsive1494933repulsive
revulsive15113703revulsive
rusine63916593_rusine
seducive1444213seducive
sluice849513slu_ice
suasive1037853suasive
tensive10269913tensive
tussive1035303tussive
visive1257873_visive
wellsite1145133wellsite

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271076.90619407.3
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.37224239.1
 
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.