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

171 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
lido5602817(None) 
dido66528211dido
fido87726411fido
lid47453531lid_
lidos65219891lidos
lids56336471lids
lilo46731571lilo
limo65529741limo
lino46343381lino
ado49146882_ado
aid49269092aid_
aide56045012aide
aids57846372aids
amido85720992amido
azido155411552azido
bid67751822bid_
bide76041512bide
bidi78226602bidi
bids75838462bids
bio57846092bi_o
biro66131222biro
ciao64924192ciao
dado67126342dado
did56850532did_
didos76820822didos
didy99121522didy
dildo71911782dildo
dino56036762dino
do310155262__do
dodo66024922dodo
eddo63411812eddo
eide55832252eide
eidos65817762eidos
elide64922652elide
fado87226472fado
fico95824602fico
fid76847702fid_
fidos95819062fidos
fids87034752fids
filo76034292filo
fino76034702fino
gid57047282gid_
gids65933752gids
giro55828642giro
glide74521602glide
hid76248392hid_
hide85134652hide
id38941852_id_
idol56818642_idol
ids47535482_ids
imido85812252imido
jiao115017852jiao
judo125315312judo
kid86540632kid_
kiddo11398962kiddo
kids96029652kids
kilo86028682kilo
kino86233632kino
kudo96115122kudo
lad48165712lad_
lade56345992lade
lads56549142lads
lady86527162lady
laid56439152laid_
led46254562led_
leno47331392leno
levo76820062levo
li29948762li__
liar47229692liar
lib57750282li_b
libido935752libido
libs66732772libs
lice66045072lice
lich96230852lich
lick106935082lick
lidar6312732lidar
lie38264532li_e
lied55838102lied
lief76037002lief
lien45339812lien
lier45942472lier
lies46454202lies
lieu46534372lieu
life75433742life
lift76942732lift
like86040852like
lilos55821872lilos
lilt46349952lilt
lily76730192lily
lima65734142lima
limb85429392limb
limbo95614812limbo
lime66244942lime
limn66527702limn
limos75320812limos
limp88432502limp
limy95727722limy
lin37967382li_n
lindy96918322lindy
line46965582line
ling57447972ling
lingo66022112lingo
link86943452link
linn46034602linn
linos55631502linos
lins47059062lins
lint416266242lint
liny78141332liny
lion46334452lion
lip514755812li_p
lipa68425932lipa
lipe66839742lipe
lips67141452lips
lira46928692lira
lire47845302lire
liri45128262liri
lirot5430032lirot
lis37162282li_s
lisp68926892lisp
list47055352list
lit39377322li_t
lite47054552lite
litho86513782litho
lits46252502lits
litu47631572litu
live76541002live
lo28053442l__o
lobo67229862lobo
loco67030742loco
lode56240122lode
logo57931762logo
loid55531502loid_
loids66220712loids
loo38359822l_oo
lude55331652lude
mid67354482mid_
midi75628492midi
mids76541802mids
milo65536112milo
misdo85413192misdo
miso67229912miso
nide55535802nide
nidi56524412nidi
olio46829672oli_o
ordo54622362ordo
piso66727572piso
redo56029372redo
rid46754642rid_
ride55945142ride
rids56539562rids
side55444502side
sidh86223002sidh
silo46037922silo
slid55828992slid_
slide64725422slide
tide55237392tide
tidy86822432tidy
tiro46832372tiro
udo49027312_udo
undo55620162undo
updo76712892updo
vid77241822vid_
vide85432772vide
video96014962video
vids85627552vids
vino76128442vino
wide85235422wide
widow1278942widow
wino75933622wino
yid76640842yid_
yids85224972yids

Search took 2 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 Filter178691298720.296603685.8
2DLD Change Limit298721710.90632971.3
3Display Results1711710.0305700.0
 (SQL Overall)1786911711.232145041.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.