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
lido5602816(None) 
dido66528201dido
fido87726401fido
lid47453521lid_
lidos65219881lidos
lids56336461lids
lilo46731561lilo
limo65529731limo
lino46343371lino
ado49146872_ado
aid49269082aid_
aide56045002aide
aids57846362aids
amido85720982amido
azido155411542azido
bid67751812bid_
bide76041502bide
bidi78226592bidi
bids75838452bids
bio57846082bi_o
biro66131212biro
ciao64924182ciao
dado67126332dado
did56850522did_
didos76820812didos
didy99121512didy
dildo71911772dildo
dino56036752dino
do310155252__do
dodo66024912dodo
eddo63411802eddo
eide55832242eide
eidos65817752eidos
elide64922642elide
fado87226462fado
fico95824592fico
fid76847692fid_
fidos95819052fidos
fids87034742fids
filo76034282filo
fino76034692fino
gid57047272gid_
gids65933742gids
giro55828632giro
glide74521592glide
hid76248382hid_
hide85134642hide
id38941842_id_
idol56818632_idol
ids47535472_ids
imido85812242imido
jiao115017842jiao
judo125315302judo
kid86540622kid_
kiddo11398952kiddo
kids96029642kids
kilo86028672kilo
kino86233622kino
kudo96115112kudo
lad48165702lad_
lade56345982lade
lads56549132lads
lady86527152lady
laid56439142laid_
led46254552led_
leno47331392leno
levo76820062levo
li29948752li__
liar47229682liar
lib57750272li_b
libido935752libido
libs66732762libs
lice66045062lice
lich96230842lich
lick106935072lick
lidar6312722lidar
lie38264522li_e
lied55838092lied
lief76036992lief
lien45339802lien
lier45942462lier
lies46454192lies
lieu46534362lieu
life75433732life
lift76942722lift
like86040842like
lilos55821872lilos
lilt46349942lilt
lily76730182lily
lima65734132lima
limb85429382limb
limbo95614812limbo
lime66244932lime
limn66527692limn
limos75320812limos
limp88432492limp
limy95727712limy
lin37967372li_n
lindy96918312lindy
line46965572line
ling57447962ling
lingo66022112lingo
link86943442link
linn46034592linn
linos55631502linos
lins47059052lins
lint416266232lint
liny78141322liny
lion46334442lion
lip514755802li_p
lipa68425922lipa
lipe66839732lipe
lips67141442lips
lira46928682lira
lire47845292lire
liri45128252liri
lirot5430032lirot
lis37162272li_s
lisp68926882lisp
list47055342list
lit39377312li_t
lite47054542lite
litho86513782litho
lits46252492lits
litu47631562litu
live76540992live
lo28053442l__o
lobo67229862lobo
loco67030742loco
lode56240112lode
logo57931762logo
loid55531492loid_
loids66220702loids
loo38359822l_oo
lude55331642lude
mid67354472mid_
midi75628482midi
mids76541792mids
milo65536102milo
misdo85413182misdo
miso67229902miso
nide55535792nide
nidi56524402nidi
olio46829672oli_o
ordo54622352ordo
piso66727562piso
redo56029362redo
rid46754632rid_
ride55945132ride
rids56539552rids
side55444492side
sidh86222992sidh
silo46037912silo
slid55828982slid_
slide64725412slide
tide55237382tide
tidy86822422tidy
tiro46832362tiro
udo49027302_udo
undo55620152undo
updo76712882updo
vid77241812vid_
vide85432762vide
video96014952video
vids85627542vids
vino76128432vino
wide85235412wide
widow1278932widow
wino75933612wino
yid76640832yid_
yids85224962yids

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.280638182.1
2DLD Change Limit298721710.90632971.3
3Display Results1711710.0463717.4
 (SQL Overall)1786911711.232145041.4
 
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.