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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
lianes6381932(None) 
lanes54946791l_anes
lianas63713381lianas
liane54720661liane_
liangs74410591liangs
lines57054571li_nes
aliases7914492aliases
alines65735222ali_nes
alkanes113812932alkanes
anes45255932__anes
banes74945582_banes
biases84618432biases
bines76946792bi_nes
canes75350372_canes
cines75239682ci_nes
clines84926042cli_nes
cranes84330752cranes
dienes75719902dienes
dines66449152di_nes
fanes84639892_fanes
fiances12310672fiances
fines86644262fi_nes
flanes94522422flanes
giants74713502giants
inanes62519802inanes
janes124928122_janes
kanes95529372_kanes
kiangs11378362kiangs
kines95039132ki_nes
laces76141762l_aces
lades65141272l_ades
lakes95737652l_akes
lames75445542l_ames
lances84824102l_ances
lands65426902l_ands
lane45153332l_ane_
lares54852632l_ares
lases54944762l_ases
laves86039152l_aves
laxes125430092l_axes
lazes145129572l_azes
leaned73422542leaned
leaner64022192leaner
leaners73718172leaners
leanest7415862leanest
leans55536252lean_s
leases65428112leases
leaves94222382leaves
lenes54738522l_enes
leones64417722leones
liaise6310692liaise
liaises7311052liaises
liana53915892lian_a
liang64914412lian_g
liards75212612liards
liars54723162lia_rs
liches114724292liches
lieges74113442lieges
liens56525502lien_s
liernes739622liernes
lies46454192li__es
ligands9438982ligands
ligans76817732ligan_s
ligases82310712ligases
ligates82318382ligates
likens105613702likens
likes96231902li_kes
lilies63021412lilies
limans84816302liman_s
limens84618032limens
limes75636502li_mes
limned94811472limned
limner84112872limner
limners93311562limners
limns75718392limn_s
linacs8310812linacs
linages8813172linages
lindanes939172lindanes
line46965572li_ne_
lined64934642li_ned
linen55728722li_nen
linens64818392li_nens
liner55938922li_ner
liners65428852li_ners
liney87029632li_ney
lings67135772li_ngs
links96430192li_nks
linnet6419422linnet
linnets739832linnets
linns56123332li_nns
linos55631502li_nos
lins47059052li_n_s
lints57137192li_nts
lioness739102lioness
lions55923212lion_s
lipases9209482lipases
lisles63416282lisles
litanies8310992litanies
litres65220392litres
livens94314892livens
lives86133192li_ves
livres94311862livres
llanos6108332llanos
loaned73816292loaned
loaner64416502loaner
loaners73913622loaners
loans56026462loan_s
loaves94813852loaves
lunes55337772l_unes
lyases95211872lyases
manes76648962_manes
mines75651952mi_nes
nines55937342ni_nes
panes76148692_panes
pianos84315932pianos
pians75126962pian_s
pines76048862pi_nes
planes85028082planes
sanes55649072_sanes
silanes72517162silanes
sines55954822si_nes
stanes64933402stanes
thanes94918982thanes
tines54848422ti_nes
tisanes7311852tisanes
vanes85130972_vanes
viands1047812viands
vines85137642vi_nes
wanes85040882_wanes
wines85546862wi_nes
zines145232652zi_nes

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511312.50033020.4
3Display Results1311310.0502620.0
 (SQL Overall)1786911312.89361766.7
 
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.