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

147 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
libido93575(None) 
libidos1044651libidos
aikido1135472aikido
imido85812242_imido
lido56028162l__ido
lipid85916172lipid_
lipide93511062lipide
lipids94310922lipids
livid96714422livid_
abide86223713_abide
aikidos1253883aikidos
albedo956123albedo
albino839933albino
alibi7514233alibi__
alibied1038143alibied
alibies9313323alibies
alibis8311073alibi_s
amido85720983_amido
azido155411543_azido
bid67751813__bid_
bide76041503__bide
bidi78226593__bidi
bids75838453__bids
bifid11910703bifid_
bio57846083__bi_o
biro66131213__biro
cabildo1254723cabildo
cebid104314073cebid_
cebids11439173cebids
dido66528203__dido
dildo71911773di_ldo
divide113410893divide
fido87726403__fido
finito9310303finito
gibed96215963gibed_
gibing103712353gibing
ibidem1134793_ibidem
ibis66519583_ibi_s
imid76122293_imid_
imide85716893_imide
imids86015143_imids
imino74315233_imino
irid55927173_irid_
irids66417773_irids
jibed155114163jibed_
jibing16379623jibing
kibitz2177643kibitz
kiddo11398953ki_ddo
labia75219013labi_a
labial84714343labial
labile8315223labile
labium10410243labium
ladino73615123ladino
laid56439143l_aid_
latigo73410013latigo
latino64120473latino
liaise6310693liaise
liaison744473liaison
liard65418593liard_
liards75212613liards
lib57750273lib___
libber104414013libber
libel74116103lib_el
libels85112693libels
liber74723623lib_er
libers84721443libers
liblab1035083liblab
libra74712423lib_ra
librae84310173librae
libras83711703libras
libri74610113lib_ri
libs66732763lib__s
licit74327683lici_t
lid47453523l__id_
lidos65219883l__idos
lids56336463l__ids
lied55838093li_ed_
liked104523813liked_
liking114319583liking
lilied73913213lilied
lilies63021413lilies
lilo46731563l__ilo
limbed114513183limbed_
limbi96513813limbi__
limbic12528743limbi_c
limbier11349113limbier
limbing123410423limbing
limbo95614813li_mbo
limed85426803limed_
limier83518723limier
limina83514503limina
liming94021243liming
limit73126343limi_t
limits82514143limits
limo65529733l__imo
limpid11389753limpid_
lindy96918313li_ndy
lined64934643lined_
lingo66022113li_ngo
linier64423793linier
linin58025523lini_n
lining74526803lining
linins65922143linins
lino46343373l__ino
lipides103810623lipides
lipidic1244743lipidic
lipin75518893lipi_n
lipins85016883lipins
lipoid9411043lipoid_
lipoids1038233lipoids
liquid1637143liquid_
liquids1735823liquids
liri45128253liri__
litho86513783li_tho
lived95523723lived_
lividly1434783lividly
livier97514593livier
living104318323living
lobed86022133lobed_
lobo67229863lob__o
loid55531493l_oid_
loids66220703l_oids
lubed85319893lubed_
lubing94114043lubing
lucid84314573lucid_
lurid64618973lurid_
mikado1344513mikado
misdo85413183mi_sdo
nitid61817833nitid_
rabid84520783rabid_
rebid85121363rebid_
rebids94015533rebids
ribier84414233ribier
rigid7913893rigid_
rubigo935053rubigo
subito8410453subito
tabid84418263tabid_
tibia7312403tibi_a
tibiae838483tibiae
tibial849843tibial
tibias839953tibias
timid84815733timid_
unbid83214643unbid_
vibist11610583vibist
vibrio1136223vibrio
virid94116043virid_
vivid125112313vivid_

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161474.70323966.8
3Display Results1471470.0463195.7
 (SQL Overall)1786911475.12534866.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.