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

222 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
labiates10101151(None) 
labiate91313571labiate_
labiated11109301labiated
abates85825032_ab_ates
ablates92416902_ablates
albites9313202albi_tes
aviates10313062_aviates
glaciates1267352glaciates
labials9299872labia_ls
lactates10311232lactates
laminates112712902laminates
lapidates1247142lapidates
lariated91212062lariated
lariats7615052lariat_s
librates103412952librates
radiates92415292radiates
satiates8314632satiates
variates111214982variates
abases85720773_ab_ases
abate76627843_ab_ate_
abated95918453_ab_ated
abater85518123_ab_ater
abaters95115203_ab_aters
abatis84317933_ab_atis
abdicates1448153_abdicates
abides94719893_abi_des
abioses9311493_abioses
ablate82219213_ablate_
ablated102513443_ablated
abrades10312073_abrades
abwatts1233403_abwatts
aerates74627493_aerates
agates76121343_a_gates
agitates9310883_agitates
agnates82813193_agnates
alates64833973_a_lates
albatas938373alb_atas
albite8313313albi_te_
alginates10310123alginates
aliases7914493_aliases
amirates101114793_amirates
animates101316423_animates
annates72415423_annates
aviate9315203_aviate_
aviated11310263_aviated
axites134913833_axi_tes
babiches1735253babiches
babies106123653babi__es
barites94322333bari_tes
bates75846343__b_ates
batistes1039713batistes
biases84618433__biases
bilabiate1344573bilabiate_
bites75641173__bi_tes
bloviates1484543bloviates
cabbages1537203cabbages
cabinets1238283cabinets
cabinmates1643893cabinmates
califates14310113califates
capiases1239253capiases
carates95630613ca_rates
caseates10313713caseates
caudates11310263caudates
caviares1337993caviares
cavitates14168963cavitates
ciliates10413453ciliates
craniates11310653craniates
dacites101114593daci_tes
debates103718533deb_ates
deviates12312733deviates
elaborates1246313elaborates
eluviates1246103eluviates
emaciates1347883emaciates
eradiates102010783eradiates
expiates17810213expiates
fabricates1746463fabricates
fabulates1447733fabulates
filiates11412663filiates
flatmates1446193flatmates
fleabites1443613fleabi_tes
foliates11412753foliates
gabies93820733gabi__es
gallates92815533gallates
glabrate1146043glabrate_
glaciate1168083glaciate_
glaciated1365763glaciated
gladiate1057053gladiate_
habitans1346623habitans
habitats1346733habitats
habited1337883habi_ted
habits113014653habi_t_s
habituates1543633habituates
habitues13306413habitues
habitus12338173habi_tus
halites103221193hali_tes
hamates122917683ha_mates
jubilates1845843jubilates
kalifates1646133kalifates
karates115617473ka_rates
labia75219013labia___
labial84714343labia__l
labialities1347033labialities
labializes2145793labializes
labially1336983labially
labile8315223labi_le_
labilities12712233labilities
laborites1149263laborites
labrets939363labret_s
lacerates112413783lacerates
lactases1038523lactases
lactate9312703lactate_
lactated1138873lactated
ladies75124883ladi__es
laities7320343la_ities
laliques1744833laliques
lambastes13114693lambastes
lambies113015113lambi__es
lamiae84817453lamia_e_
lamias85020613lamia__s
laminate103014633laminate_
laminated122610283laminated
lamister1037653lamister
lamisters1157123lamisters
lampases1267293lampases
lanate6421263la_nate_
lanated8313203la_nated
lancinates1247153lancinates
laniards967313laniards
laniaries9411223laniaries
lanitals837723lanitals
lapidate1157903lapidate_
lapidated1345673lapidated
lapides103012043lapi_des
lapises93513463lapi_ses
lariat6629043lariat__
latices9313763lati_ces
latigoes9306163latigoes
lattes65324203la__ttes
laureates987683laureates
lavages1138603la_vages
lavishes1457403lavishes
lawines103313563lawi_nes
laxities1539093laxities
layettes1136263layettes
lazies154418783lazi__es
leachates1446663leachates
legates82917683l_egates
lenites7818443leni_tes
levigates1346493levigates
levirates1247493levirates
levitates1247863levitates
lianes63819323l__ianes
liberates111012943liberates
librate93214233librate_
librated113110313librated
ligates82318383l_igates
limites92915453limi_tes
liquates1737453liquates
litigates1048003litigates
lobate82915243lob_ate_
lobated102610943lob_ated
locates93218813l_ocates
loricates11310123loricates
lubricates1446053lubricates
lucites9311863luci_tes
luxates1436973l_uxates
lysates10317473l_ysates
magnates11511613magnates
malates93522613ma_lates
maleates103316343maleates
mandates11314093mandates
marinates112516383marinates
mediates112814063mediates
muriates10312083muriates
naiades838213na_iades
narrates8312763narrates
navigates1345873navigates
oblates91913243_oblates
obviates1345153obviates
opiates9312143_opiates
paginates123111363paginates
palates93624943pa_lates
palliates11311033palliates
palpates122613063palpates
parietes10714543parietes
patinates113814693patinates
patriates11311363patriates
placates12311753pla_cates
playdates1554903playdates
playmates1646603playmates
rabatos93010903rab_atos
rabats83116223rab_at_s
rabbinates1444513rabbinates
rabies85226023rabi__es
radiate83416313radiate_
radiated102512593radiated
radicates12412073radicates
ratites74920683rati_tes
rebates95123183reb_ates
sabbaths1543973sabbaths
sabbats1138633sabbat_s
sabines94318483sabi_nes
salivates1239293salivates
samites93118713sami_tes
sanitates9611733sanitates
satiate7315403satiate_
satiated9311603satiated
savates10312953sa_vates
seriates82620673seriates
sibilates1148443sibilates
striates83417083striates
sublates10315003sublates
tabulates1139143tabulates
tannates81911953tannates
taxites1449673taxi_tes
vacates12312833va_cates
validates1338243validates
valuates112811203valuates
variate101316433variate_
variated121211393variated
vibrates132210613vibrates
vitiates112311433vitiates

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622226.70021815.2
3Display Results2222220.0962312.5
 (SQL Overall)1786912227.21924752.9
 
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.