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

217 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
librates10341295(None) 
liberates111012941liberates
librate93214231librate_
librated113110311librated
vibrates132210611vibrates
calibrates1446952calibrates
citrates102315092citrates
disrates91118152disrates
labiates101011512labiates
liberate101113382liberate_
liberated1299472liberated
librae84310172libra_e_
libraries1146992libraries
libras83711702libra__s
ligates82318382li_gates
liquates1737452liquates
literates91415652literates
migrates111112852migrates
misrates101318242misrates
nitrates82516222nitrates
picrates122013212picrates
pirates93020332pi_rates
titrates82314662titrates
vibrate122811522vibrate_
vibrated14228392vibrated
vibratos13217482vibratos
abates85825033_ab_ates
ablates92416903_ablates
abrades10312073_abrades
acierates11310813acierates
aerates74627493_aerates
airdates939723airdates
alienates9310683alienates
aliterates101510753aliterates
amirates101114793amirates
bates75846343__b_ates
berates94126873_berates
borates94823013_borates
braces108427773__braces
braes75735053__bra_es
brakes124923123__brakes
brats75336013__brat_s
braves115524083__braves
brazes175522193__brazes
brutes86118683__brutes
calibrate1347743calibrate_
calibrated1545643calibrated
carates95630613_carates
celebrates1447673celebrates
celibates1358633celib_ates
cerates95428253_cerates
ciliates10413453ciliates
cirrate92413493cirrate_
citrate92216803citrate_
citrated112712253citrated
climates12311973cli_mates
clofibrates1851753clofibrates
crates85736063__crates
curates95323833_curates
debates103718533deb_ates
deliberates1446793deliberates
derates84028893_derates
dictates11311383dictates
dilates83220663di_lates
diorites9313523diorites
disrate81418523disrate_
disrated10915573disrated
elaborates1246303elaborates
embraces14128873embraces
embrutes1245193embrutes
emigrates1248583emigrates
emirates101214853emirates
ferrates113013423ferrates
fibrannes1443533fibrannes
fibres114312123fibr__es
fibroses1345973fibroses
filiates11412663filiates
filtrates1247733filtrates
fixates1737393fi_xates
glabrate1146033glabrate_
grates75429893__grates
gyrates113610263_gyrates
hibernates1544623hibernates
hydrates15229413hydrates
ideates8313733_ideates
imbrutes1244203imbrutes
ingates82716913_ingates
ingrates9514173ingrates
inmates92715783_inmates
iodates8312903_iodates
irades74517393_i_rades
irate55627983_i_rate_
irater65218353_i_rater
iratest7312483_i_ratest
iterates81317823iterates
karates115617473_karates
labiate91313573labiate_
labiated11109303labiated
laborites1149253laborites
labrets939363labret_s
lacerates112413773lacerates
lactates10311223lactates
laureates987683laureates
legates82917683l_egates
levirates1247493levirates
lianes63819323li__anes
libelees10227213libelees
liberals1039413libera_ls
liberator1147063liberator
liberators1247013liberators
liberties1149203liberties
liblabs1144123libla_bs
libra74712423libra___
library1245323libra_ry
librating1239053librating
libration111510163libration
librations12149063librations
libratory14255803libratory
libretti1043583libretti
libretto1043703libretto
librettos1153593librettos
liernes739623lier_nes
liftgates1343513liftgates
ligases82310713li_gases
ligate72519253li_gate_
ligated92414143li_gated
lignites9129613lignites
limbate1139213limbate_
limeades11116643limeades
limites92915453li_mites
linages8813173li_nages
lindanes939173lindanes
lineages979183lineages
lineate7815153lineate_
lineated9711063lineated
linkages1385953linkages
lipases9209483li_pases
liquate1638423liquate_
liquated1835493liquated
liras56021983li_ra__s
literate81216893literate_
literatus9146823literatus
litigates1048003litigates
litotes7311183li_totes
litres65220393litr__es
livres94311863livr__es
lobate82915243lob_ate_
lobated102610943lob_ated
locates93218813l_ocates
lubricates1446053lubricates
lucubrates1443163lucubrates
lustrates939463lustrates
luxates1436973l_uxates
lyrate94112103l_yrate_
lyrated11388473l_yrated
lysates10317473l_ysates
meliorates1288903meliorates
migrate101314173migrate_
migrated121110513migrated
mirages102213533mi_rages
misdates111113633misdates
mismates121114563mismates
misrate91319143misrate_
misrated111315383misrated
narrates8312763narrates
nictates1039593nictates
nidates8311893ni_dates
niobates1037283niobates
nitrate72017013nitrate_
nitrated92213153nitrated
nitrites82313453nitrites
oblates91913243_oblates
operates10515413operates
orates64328613__orates
outrates82421373outrates
phorates13413043phorates
picrate112014143picrate_
picrated132110113picrated
picrites121811083picrites
pirate82322883pi_rate_
pirated102515613pi_rated
prates84633163__prates
priorates11410763priorates
prorates10418073prorates
rates55352013___rates
rebates95123183reb_ates
recrates102420373recrates
regrates92618403regrates
revibrates1546273revibrates
serrates82617023serrates
sibilates1148443sibilates
sinuates8310963sinuates
situates8310373situates
sorbates10311103sorbates
sublates10315003sublates
subraces12313033subraces
tirades8311723ti_rades
titrate72215573titrate_
titrated92611683titrated
ulcerates1148853ulcerates
umbrages1336623umbrages
unbraces12229413unbraces
unbrakes14258413unbrakes
uncrates10314563uncrates
uprates93814863_uprates
urates65027763__urates
vibrances1645763vibrances
vibrants1345913vibrants
vibrato12247383vibrat_o
vibrator13227343vibrator
vibrators14237253vibrators
vicarates1487623vicarates
violates11311193violates
virgates1237923virgates
vitiates112311433vitiates
vizirates2144663vizirates
zincates1937743zincates

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622177.72018932.9
3Display Results2172170.0762855.3
 (SQL Overall)1786912178.21921741.2
 
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.