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

254 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
librate9321423(None) 
liberate101113381liberate
librae84310171libra_e
librated113110311librated
librates103412951librates
vibrate122811521vibrate
calibrate1347752calibrate
cirrate92413492cirrate
citrate92216802citrate
disrate81418522disrate
glabrate1146042glabrate
irate55627982_i_rate
labiate91313572labiate
liberated1299472liberated
liberates111012942liberates
libra74712422libra__
library1245322library
libras83711702libra_s
ligate72519252li_gate
limbate1139212limbate
lineate7815152lineate
liquate1638422liquate
literate81216892literate
lobate82915242lob_ate
lyrate94112102l_yrate
migrate101314172migrate
misrate91319142misrate
nitrate72017012nitrate
picrate112014142picrate
pirate82322882pi_rate
titrate72215572titrate
vibrated14228392vibrated
vibrates132210612vibrates
vibrato12247382vibrato
abate76627843_ab_ate
ablate82219213_ablate
abrade9313053_abrade
acerate92818913acerate
acierate10311813acierate
aerate64830553_aerate
airdate8311323airdate
alienate8311553alienate
aliterate91611343aliterate
amirate91115953amirate
aurate64426473_aurate
barbate11314543barbate
bate66552423__b_ate
berate84729023_berate
biforate1346903biforate
binate8419773bi_nate
bistate9313823bistate
blate75933783__blate
borate85026153_borate
brace95629273__brace
brae65639113__bra_e
brake116025343__brake
brat66055543__brat_
brats75336013__brats
brave104925503__brave
braze165423453__braze
brute75321783__brute
calibrated1545653calibrated
calibrates1446963calibrates
carate84734003_carate
celebrate1348093celebrate
celibate1259313celib_ate
cerate84829463_cerate
ciliate9514603ciliate
citrated112712253citrated
citrates102315093citrates
climate11312833cli_mate
clofibrate1751793clofibrate
crate76537403__crate
curate85226243_curate
debate94419193deb_ate
deliberate1347123deliberate
derate74531233_derate
dictate10311663dictate
dilate73220693di_late
diorite8314913diorite
disrated10915573disrated
disrates91118153disrates
dolabrate1244493dolabrate
elaborate1146893elaborate
embrace1388893embrace
embrute1145703embrute
emigrate1149603emigrate
emirate91015833emirate
ferrate103014043ferrate
fibranne1343373fibranne
fibre104812843fibr__e
figurate1237193figurate
filiate10414233filiate
filtrate1148223filtrate
fimbriate1643823fimbriate
fissate103010033fissate
fixate1638733fi_xate
globate1057823glob_ate
grate64932883__grate
gyrate104912523_gyrate
hibernate1444993hibernate
hydrate14239813hydrate
ideate7313683_ideate
imbrute1144913imbrute
ingate73018243_ingate
ingrate8715123ingrate
inmate82917363_inmate
innate63917313_innate
iodate7313503_iodate
irade65618153_i_rade
irater65218353_i_rater
iterate71119113iterate
karate105320923_karate
labiated11109303labiated
labiates101011513labiates
laborite10410703laborite
labra75415463labra__
labret8320223labret_
labrets939363labrets
lacerate102214713lacerate
lactate9312703lactate
lanate6421263l_anate
late47560483l___ate
laurae64011663laura_e
laureate888023laureate
legate72917453l_egate
levirate1147623levirate
liane54720663li__ane
libelee92510983libelee
liberal9310193libera_l
liberals1039413liberals
liberator1147063liberator
liberty1237163liberty
liblab1035083libla_b
liblabs1144123liblabs
libraries1146993libraries
librating1239053librating
libration111510163libration
libratory14255803libratory
libretti1043583libretti
libretto1043703libretto
libri74610113libr__i
licente91210893licente
lierne638023lier_ne
liftgate1243413liftgate
ligase7259913li_gase
ligated92414143li_gated
ligates82318383li_gates
lignite81310303lignite
ligulate92510253ligulate
limeade1076123limeade
linage7713403li_nage
lindane839033lindane
lineage878983lineage
lineated9711063lineated
linkage1295963linkage
lipase8239103li_pase
liquated1835493liquated
liquates1737453liquates
lira46928683li_ra__
liras56021983li_ra_s
lire47845293li_r__e
lirot5430033li_rot_
liroth938383li_roth
lisente71210703lisente
lite47054543li___te
literates91415653literates
literati81210803literati
litigate948303litigate
litre55421463litr__e
livre85613253livr__e
lobated102610943lob_ated
lobulate1078833lobulate
locate83919843l_ocate
lubricate1346443lubricate
lucubrate1343373lucubrate
lunate6316043l_unate
lustrate8310443lustrate
luxate1338083l_uxate
lyrated11388473l_yrated
lysate9388103l_ysate
meliorate1179493meliorate
migrated121110513migrated
migrates111112853migrates
mirage92313653mi_rage
misate81222693mi_sate
misdate101413963misdate
mismate111415353mismate
misrated111315383misrated
misrates101318243misrates
narrate7313493narrate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrated92213153nitrated
nitrates82516223nitrates
nitrite72314463nitrite
oblate82214743_oblate
operate9615733operate
orate55133303__orate
outrate72323183outrate
overate10620963overate
phorate12413363phorate
picrated132110113picrated
picrates122013213picrates
picrite111911313picrite
pileate93815923pileate
pinnate93613743pinnate
pirated102515613pi_rated
pirates93020333pi_rates
plicate11314513pli_cate
prate75135983__prate
priorate10411733priorate
prorate9418733prorate
rate45458763___rate
rebate84424113reb_ate
recrate92621663recrate
regrate82618663regrate
revibrate1446383revibrate
serrate73017543serrate
sibilate1049533sibilate
sigmate10710143sigmate
sinuate7412163sinuate
situate7410783situate
sorbate9311733sorbate
sublate9315363sublate
subrace11313003subrace
tibiae838483tibia_e
tirade7311693ti_rade
titrated92611683titrated
titrates82314663titrates
tubate82813173tub_ate
ulcerate1039733ulcerate
umbrae1038683umbra_e
umbrage1236723umbrage
unbrace111910493unbrace
unbrake13239123unbrake
uncrate9415953uncrate
uprate83916543_uprate
urate55432163__urate
vibrance1545863vibrance
vibrant12410393vibrant
vibrants1345913vibrants
vibratile1443663vibratile
vibrative1745583vibrative
vibrator13227343vibrator
vibratos13217483vibratos
vicarate1378603vicarate
violate10311553violate
virgate1138733virgate
vitiate103412953vitiate
vittate10409733vittate
vizirate2045353vizirate
zincate1838533zincate

Search took 8 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 Filter1786911340270.440406115.9
2DLD Change Limit1340272546.98319193.3
3Display Results2542540.0962645.8
 (SQL Overall)1786912547.51923765.3
 
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.