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

140 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
listening1012895(None) 
glistening1294281glistening
blistering13107062blistering
distending1348332distending
fastening13268602fastening
glistering12106422glistering
hastening13259482hastening
kittening1434592kittening
latening9711492l_atening
leistering1147982leistering
lessening1045332lessening
lichening1545672lichening
lightening15255052lightening
likening13246892li_kening
lippening14234942lippening
listing84020592list__ing
littering102411982littering
livening12248152li_vening
lustering102711202lustering
mistending1447952mistending
mistuning1237672mistuning
moistening1346232moistening
sistering101213752sistering
aliening91510893ali__ening
battening12268853battening
bitewing1435293bi_tewing
bittering122511993bittering
blustering13106183blustering
chastening1656523chastening
christening1743403christening
cloistering1444823cloistering
clustering13116813clustering
crispening1543873crispening
destining11311433destining
discerning1447863discerning
disowning1446113disowning
dispending1547923dispending
dispensing1448233dispensing
dissenting121310293dissenting
distaining1248903distaining
distancing1447083distancing
dizening19177143di_zening
fastenings14273903fastenings
fattening13287833fattening
festering132413173festering
filtering13199723filtering
fisting113818123fist__ing
flattening14115103flattening
flittering1486503flittering
flustering14105933flustering
fostering132411263fostering
glittering1296003glittering
histing113720373hist__ing
hosteling1337893hosteling
intending1139983_intending
interning10315253_interning
intoning9311123_intoning
iteming1037753_i_teming
jittering17218423jittering
ladening1078823l_adening
lasting84725243last__ing
leadening1176733leadening
leavening1365973leavening
lesioning1046443lesioning
lessoning1044773lessoning
lettering102112073lettering
libeling1139873li_beling
licencing1443853li_cencing
licensing1244753li_censing
lichenin1345053lichenin_
lichenins1444843lichenins
lifting113313273lift__ing
lightering15246113lightering
lightning14286023lightning
lilting83515383lilt__ing
limbering1488793limbering
limning103710323li__mning
lingering11310513lingering
lining74526803li___ning
linting83820983lint__ing
lippering14217883lippering
lisping103412753lis__ping
listen64816813liste__n_
listened9168813listen_ed
listener8158313listen_er
listeners9147323listeners
listens74014133liste__ns
listeria839433listeri_a
listerias959233listerias
listings93310043list__ings
lithoing1236743li_thoing
livering122012383li_vering
lobstering1345123lobstering
loitering1039683loitering
loosening1044933loosening
loudening1144743loudening
lusting83619323lust__ing
lustring9269723lust_ring
mastering122315303mastering
mildening1345673mildening
misatoning1346443misatoning
mispenning1545773mispenning
missending1446493missending
mistaking1699693mistaking
misterming1538603misterming
mistiming1438913mistiming
misting103623383mist__ing
mistyping1744723mistyping
mitering113015403mi_tering
mustering122212333mustering
neatening1038353neatening
oystering1337563oystering
pestering122315663pestering
pinkening1634993pinkening
pistoling1268493pistoling
plaistering1444603plaistering
plastering1339243plastering
quietening2043613quietening
rattening10288763rattening
richening1546223richening
ripening1138573ri_pening
roistering1148583roistering
sickening1635993sickening
sintering101014803sintering
slickening1743903slickening
softening1365493softening
staning83922243__staning
stewing113412493__stewing
stoning83717443__stoning
tautening1035843tautening
tightening15153943tightening
tittering102310313tittering
viseing11299163vis_e_ing
visioning1347063visioning
westering132112643westering
whitening1635103whitening
widening13237833wi_dening
wintering13412363wintering
wisting113519743wist__ing
wizening21255463wi_zening

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 Limit1486411406.12324275.8
3Display Results1401400.0632222.2
 (SQL Overall)1786911406.60927037.5
 
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.