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

155 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
lindanes93917(None) 
lindane839031lindane_
blindages1343662blindages
inanes62519802_in_anes
indenes82916252_indenes
lianes63819322li__anes
linages8813172lin_ages
lindens839412linden_s
lindies8416582lind_ies
lineages979182lineages
linkages1385952linkages
linsangs944412linsangs
lurdanes936062lurdanes
windages1338262windages
airdates939723airdates
alidades1037003ali_dades
andantes9310853_andantes
bandages12310633bandages
bandanas11178573bandanas
bindings123810473bindings
bindles104016453bind_les
biplanes1238573biplanes
blindage1243683blindage_
blindness1235343blind_ness
blondines1246153blondines
bondages1237893bondages
condones112817393condones
dindles93817243dind_les
dioxanes1645373dioxanes
finales104016013fin_ales
finances1338653fin_ances
findings13328443findings
fondants1246203fondants
gliadines1144773gliadines
handaxes1938403handaxes
henbanes1336573henbanes
hindrances1644843hindrances
inane52820343_in_ane_
inaner62213543_in_aner
inanest72115363_in_anest
incages103013883_incages
incants92012803_incants
incases93615973_incases
indabas1045853_indabas
indamines1247553_indamines
indene73215373_indene_
indents83114663_indents
indexes15339453_indexes
indices103513443_indices
indies73822783_ind_ies
indites83618983_indites
indoles83716363_indoles
induces103611813_induces
indues73515263_ind_ues
infantes11249633_infantes
infants102210773_infants
infares10313023_infares
ingates82716913_ingates
inhales10511863_inhales
inlaces92512903_inlaces
inlands838783_inlands
inmates92715783_inmates
innages82911303_innages
insane6314893_insane_
insaner7310443_insaner
insanest8410343_insanest
intakes11310943_intakes
intines7921113_intines
intones7816543_intones
invades11118293_invades
iodates8312903_iodates
iodines83616633_iodines
kinases113511123kin_ases
kindles123614843kind_les
kindness13236653kind_ness
landaus8310343landa_us
landings103110073landings
landlines1039763landlines
lanes54946793l___anes
lantanas838263lantanas
lianas63713383li__anas
liane54720663li__ane_
liangs74410593li__angs
librates103412953librates
lidars7310783li_da_rs
liernes739623li_ernes
ligands9438983li_gands
ligans76817733li_gan_s
ligases82310713li_gases
ligates82318383li_gates
lignans8398853lignan_s
limans84816303li_man_s
limeades11116643limeades
linacs8310813lin_a_cs
linage7713403lin_age_
linden7411453lind__en
lineage878983lineage_
lineate7815153lineate_
lineated9711063lineated
linens64818393lin_en_s
lines57054573li___nes
lingams104510193linga_ms
lingas75116573linga__s
lingoes84014693lin_goes
linguines1046513linguines
linings84313073lin_ings
linins65922143lin_in_s
linkage1295963linkage_
linnet6419423lin__net
linnets739833lin__nets
linns56123333lin__n_s
linsang835863linsan_g
lipases9209483li_pases
liquates1737453liquates
litanies8310993li_tanies
longans84510813longan_s
lungans8399053lungan_s
lurdane835983lurdane_
lurdans837073lurdan_s
mandates11314093mandates
mintages111110513mintages
minyans1237263minyan_s
misdates111113633misdates
montanes101114523montanes
mundane1038073mundane_
nidates8311893ni_dates
nondances1247803nondances
pandanus1136433pandanus
pendants1139093pendants
pentanes10316083pentanes
pinangs10267793pin_angs
pinbones1238143pinbones
pinenes93416673pin_enes
pinnaces12268863pinnaces
pinones94717073pin_ones
pintanos10107553pintanos
pinwales1367963pinwales
qindars17267423qinda_rs
randans8313213randan_s
riddances1343893riddances
silanes72517163si_lanes
sinkages1386853sinkages
sinuates8310963sinuates
sundaes8313093sunda_es
tendances1247573tendances
tinwares1137913tinwares
tisanes7311853ti_sanes
undines8716083_undines
vendaces1457183vendaces
vintages12118273vintages
windage1237933windage_
windiness1337373windiness
windings13329973windings
windles113518493wind_les
zincates1937743zincates

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621557.03020791.2
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.53323721.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.