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

294 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
librae8431017(None) 
libra74712421libra_
libras83711701libras
librate93214231librate
brae65639112__brae
fibre104812842fibr_e
labra75415462labra_
laurae64011662laurae
liberal9310182liberal
liberate101113382liberate
liblab1035082liblab
library1245312library
librated113110312librated
librates103412932librates
libri74610112libr_i
lierne638022lierne
lira46928682li_ra_
liras56021982li_ras
lire47845292li_r_e
litre55421462litr_e
livre85613252livr_e
tibiae838472tibiae
umbrae1038672umbrae
vibrate122811512vibrate
abrade9313053_abrade
agorae7511203agorae
airbag956963airbag
alible8311973alib_le
aurae54128113_aurae
bare65460523__bare
bible95119413bib_le
birle75023633bi_rle
birse74517403bi_rse
blae66134643__blae
bra56339463__bra_
brace95629273__brace
brad75234343__brad
braes75735053__braes
brag75229723__brag
brake116025343__brake
bran65740383__bran
bras65746453__bras
brat66055543__brat
brave104925503__brave
braw94829563__braw
bray95232903__bray
braze165423453__braze
bree67241263__bree
brie65837903__brie
calibrate1347743calibrate
calibre1136603calibr_e
cire65836373ci_r_e
cirrate92413483cirrate
citral81113883citral
citrate92216793citrate
cobra95214403cobra_
cobras104014193cobras
dibble114013843dibble
diram84419473di_ram
dire56644143di_r_e
dirge75117073di_rge
disrate81418523disrate
dobra85013103dobra_
dobras94811913dobras
embrace1388893embrace
embrue1036523embrue
fibranne1343373fibranne
fibres114312123fibres
fibril1137163fibril
fibrin1138533fibrin
fibulae12237013fibulae
fierce11348913fierce
fimbriae1543763fimbriae
fire76245593fi_r_e
florae94713883florae
frae75330473__frae
gibe75927773gib__e
glabrate1146033glabrate
glebae9407613gleb_ae
hijra1535643hijra_
hijrah1934273hijrah
hijras1635773hijras
hire75538963hi_r_e
hiree85427803hi_ree
hydrae13258573hydrae
ihram10310183_ihram
imbrue1035133imbrue
irade65618153_i_rade
irate55627983_i_rate
ire36943173_i_r_e
jibe136323383jib__e
kibbe135211963kib_be
kibble143910953kibble
kibe106523433kib__e
kibla1139833kibla_
kiblah1535583kiblah
kiblas1239323kiblas
labara83712893labara
labia75219003labia_
labial84714333labial
labiate91313573labiate
labile8315213labile
labret8320223labret
labrum1057423labrum
lamiae84817453lamiae
laree56036293l_aree
large65325463l_arge
larvae938843larvae
laura54116203laura_
lauras63414333lauras
liable81415813liable
liaise6310693liaise
liana53915893liana_
lianas63713383lianas
liane54720663li_ane
liar47229683li__ar
liard65418593liar_d
liards75212613liards
liars54723163liar_s
lib57750263lib___
libber104414003libber
libel74116103lib_el
libeled10249413libeled
libelee92510983libelee
libeler9219003libeler
libels85112693libels
liber74723613lib_er
liberals1039413liberals
liberated1299473liberated
liberates111012933liberates
libers84721433libers
liberty1237153liberty
libido935743libido
liblabs1144123liblabs
libraries1146993libraries
libs66732753lib__s
lice66045063li__ce
lichee114017973lichee
lidar6312723li_dar
lidars7310783lidars
lie38264523li___e
liege65314433li_ege
lienal63912783lienal
lier45942463lier__
liernes739623liernes
liers55130403lier_s
lieve86315473li_eve
life75433733li__fe
ligan67920283li_gan
ligase7259913ligase
ligate72519243ligate
lignan75510323lignan
ligulae8308753ligulae
ligule74010833ligule
ligure7279473ligure
like86040843li__ke
lilac7311073li_lac
lima65734133li_ma_
liman75921603li_man
limas75627633li_mas
limba95414973limba_
limbas105313193limbas
limbate1139203limbate
lime66244933li__me
limeade1076123limeade
limpa97014463limpa_
limpas105513083limpas
linac7315413li_nac
linage7713403linage
lindane839023lindane
line46965573li__ne
lineage878983lineage
lineal65616023lineal
linear65113333linear
lineate7815153lineate
linga66820813linga_
lingam95112333lingam
lingas75116563lingas
linguae8398393linguae
linkage1295963linkage
lipa68425923li_pa_
lipase8239103lipase
lipe66839733li__pe
lipide93511063lipide
lipread1034953lipread
liquate1638413liquate
liri45128253li_r_i
lirot5430033li_rot
lisle53916723li_sle
listee64223063listee
litai55216363li_tai
litas54923773li_tas
lite47054543li__te
literal7613263literal
literate81216883literate
lithe84922013li_the
litoral7610763litoral
litres65220393litres
little63312163little
live76540993li__ve
livres94311863livres
lizard16369233lizard
lobar7313013lob_ar
lobate82915243lobate
lobe65535363lob__e
lobule82910063lobule
loral55927823l_oral
loran55925093l_oran
lore45850353l_or_e
lube64731563lub__e
lubric1097983lubric
lucre76415523lucr_e
lure45142463l_ur_e
lycra10317973lycra_
lycras11287243lycras
lyrate94112103l_yrate
lyre75623793l_yr_e
lyttae994713lyttae
mbira977953mbira_
mbiras1077143mbiras
micra96214973micra_
migrate101314163migrate
mihrab1335523mihrab
mikra114610313mikra_
minae75627723mi_nae
mirage92313653mi_rage
mire66748223mi_r_e
misrate91319143misrate
mitral81314323mitral
mitre75522423mitr_e
morae75831193_morae
nibble103713283nibble
nitrate72017013nitrate
nitre57519683nitr_e
ombre94111793ombr_e
parae76335703_parae
pibal95217323pib_al
picrate112014143picrate
pierce104010393pierce
pinnae84414643pinnae
pirate82322883pi_rate
pleurae945863pleurae
plicae10410953pli_cae
ribose839893ribose
ricrac1037013ricrac
riprap1055513riprap
sabra75317853sabra_
sabras85116363sabras
sabre74821503sabr_e
silvae92811093silvae
sire46150413si_r_e
siree55238813si_ree
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
sirree64017333sirree
subrace11313003subrace
terrae62915203terrae
tiara5315903tiara_
tiaraed837043tiaraed
tiaras6314533tiaras
tibia7312393tibia_
tibial849833tibial
tibias839943tibias
tierce8339843tierce
timbral11237183timbral
timbre10328623timbr_e
tirade7311693ti_rade
tire46143353ti_r_e
titrate72215573titrate
titre54619393titr_e
tubae74716643tub_ae
umbra948503umbra_
umbrage1236723umbrage
umbral1038623umbral
umbras1038633umbras
unbrace111910483unbrace
unbrake13239123unbrake
vibe95124493vib__e
vibrance1545843vibrance
vibrant12410393vibrant
vibrated14228383vibrated
vibrates132210593vibrates
vibrato12247383vibrato
vibrio1136223vibrio
villae95615383villae
viral86419593vi_ral
vitae84217633vi_tae
vittae93910993vittae
wire75839813wi_r_e
wirra83210823wirra_
zebra1637883zebra_
zebras1737853zebras
ziram163912893zi_ram

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.1561145455.1
2DLD Change Limit1127162945.50020493.8
3Display Results2942940.0763868.4
 (SQL Overall)1786912945.73231174.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.