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

122 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
aileron73983(None) 
ailerons849851ailerons
aleuron757382a_leuron
abler75624313abler__
aeon45634613a__e_on
aero45435343a__ero_
aglycon1342783aglycon
aider65431133aider__
aiders74524633aider_s
ailed66240283aile__d
aimer75926823aimer__
aimers84621913aimer_s
airdrop1044423airdrop
airer54927893airer__
airers64922313airer_s
airn46433833ai__r_n
aiver85725163aiver__
aivers94822323aiver_s
aldrin7311243a_ldrin
alencon945733a_lencon
alert54740653a_ler_t
alerts64418223a_lerts
aleurone846113a_leurone
aleurons867013a_leurons
alevin92511513a_levin
alexin132311483a_lexin
alien56425583alie__n
alienor7116303alienor
allegro844853allegro_
allegros945083allegros
allergen9135893allergen
allergin9136303allergin
allergy1144503allergy
andiron848283andiron
apron7318833a__pron
astern64815813aster_n
azlon144312873azl__on
bailer85425253bailer__
bailers94221353bailer_s
bicron103710773bi_cron
billion92212173billion
billon83713833bil_lon
biotron937293biotron
bolero8412093bolero_
boleros9310293boleros
caldron1038153caldron
cauldron1143243cauldron
cicero1048503cicero_
cicerone1247523cicerone
ciceroni1244853ciceroni
ciceros1158583ciceros
cinerin9313823cinerin
cistron9299883cistron
citron83112983ci_tron
diatron839283diatron
dihedron13104113dihedron
dinero75612643dinero_
dineros83812333dineros
dipteron1145593dipteron
diuron738573di_uron
elevon977953_elevon
enteron7313333enteron
erigeron944463erigeron
filemot1246703filemot
filer85433003filer__
filers94623723filer_s
fleuron1055573_fleuron
galleon8278713galle_on
giron66118993gi__ron
hailer94720343hailer__
hailers104017263hailer_s
heron85025503__heron
hyperon1548183hyperon
intron64215023_intron
iron46728463_i__ron
jailer134316683jailer__
jailers144114043jailer_s
jillion14188933jillion
kaiserin1245023kaiserin
kiloton1196313kiloton
lemon75618183__lemon
linuron746513linuron
mailer84724183mailer__
mailers94420333mailer_s
micron103714283mi_cron
midiron1046003midiron
mikron12318503mi_kron
miler75733063miler__
milers84625163miler_s
million91813143million
millrun944183millrun
nailer64119363nailer__
nailers73215893nailer_s
oiler54628283oiler__
oilers64721193oiler_s
operon8811773_operon
pauldron1142473pauldron
pigeon949413pige_on
pillion92011703pillion
pleon74216383_ple_on
pleuron976343_pleuron
polaron939843polaron
railer64524933railer__
railers74420663railer_s
sailer63526103sailer__
sailers73822323sailer_s
silicon9117533silicon
silvern10347143silver_n
tailer63823733tailer__
tailers73720183tailer_s
teleran7510173teleran
tiler56131023tiler__
tilers63523503tiler_s
viceroy1544933viceroy
vigneron1243013vigneron
viler86324163viler__
wailer93720323wailer__
wailers103916803wailer_s
waitron1036333wai_tron
wigeon1037223wige_on
wivern12409283wiver_n
zillion16188773zillion

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.406440125.6
2DLD Change Limit1340271227.37618170.7
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.82822827.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.