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

258 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
labiate9131357(None) 
labiated11109301labiated
labiates101011511labiates
abate76627842_ab_ate
ablate82219212_ablate
albite8313312albi_te
aviate9315202_aviate
bilabiate1344572bilabiate
glabrate1146032glabrate
glaciate1168072glaciate
gladiate1057052gladiate
labia75219012labia__
labial84714342labia_l
labials9299872labials
labile8315222labi_le
lactate9312692lactate
lamiae84817452lamia_e
laminate103014632laminate
lanate6421262la_nate
lapidate1157902lapidate
lariat6629042lariat_
lariated91212062lariated
lariats7615052lariats
librate93214232librate
lobate82915242lob_ate
radiate83416312radiate
satiate7315402satiate
variate101316432variate
abase76023483_ab_ase
abated95918453_ab_ated
abater85518123_ab_ater
abates85825033_ab_ates
abdicate1348903_abdicate
abide86223713_abi_de
ablated102513443_ablated
ablates92416903_ablates
ablaze17239833_ablaze
abrade9313053_abrade
abwatt11410673_abwatt
acuate8315633_acuate
adnate72913483_adnate
aerate64830553_aerate
agate66525153_a_gate
agitate8312063_agitate
agnate73314883_agnate
alate55340323_a_late
albata839333alb_ata
albites9313203albi_tes
alginate9310693alginate
amirate91115953_amirate
animate91617213_animate
ansate64517863_ansate
aurate64426473_aurate
aviated11310263_aviated
aviates10313063_aviates
axite125218253_axi_te
babiche1644573babiche
baccate131011263baccate
barbate11314543barbate
barite84224813bari_te
bate66552423__b_ate
batiste939743batiste
binate8419773__binate
bite66547003__bi_te
blate75933783__blate
bloviate1384913bloviate
cabbage1446983cabbage
cabinet11318903cabinet
cabinmate1544093cabinmate
califate13310483califate
capitate121712183capitate
carate84734003ca_rate
carinate103320243carinate
caseate9314783caseate
caudate10311353caudate
caviare1238373caviare
cavitate13159833cavitate
ciliate9514603ciliate
clavate1238713cla_vate
craniate10312563craniate
dacite91115883daci_te
debate94419193deb_ate
deviate11312713deviate
dolabrate1244493dolabrate
elaborate1146873elaborate
eluviate1146953eluviate
emaciate1248753emaciate
eradiate91911753eradiate
expiate16910593expiate
fabricate1646833fabricate
fabulate1339203fabulate
faciae112913413facia_e
falcate12311613falcate
fasciate1347563fasciate
filiate10414233filiate
flatmate1346393flatmate
fleabite1354163fleabi_te
foliate10513533foliate
galeate83916783galeate
gallate83417123gallate
glaciated1365753glaciated
glaciates1267343glaciates
globate1057823glob_ate
habile11515213habi_le
habit103027023habi_t_
habitan1236903habitan
habitat12411053habitat
habitats1346733habitats
habited1337883habi_ted
habits113014653habi_ts
habituate1443923habituate
habitue12266703habitue
halite93624233hali_te
hamate113319833ha_mate
hastate10313913hastate
jubilate1746553jubilate
kalifate1556493kalifate
karate105320923ka_rate
labara83712893lab_ara
labellate11126923labellate
labiality1446363labiality
labialize2046713labialize
labially1336983labially
lability13710833lability
labium10410243labi_um
laborite10410693laborite
labra75415463labra__
labret8320223labret_
labrets939363labrets
lacerate102214703lacerate
laciniate1156843laciniate
lactase937953lactase
lactated1138863lactated
lactates10311223lactates
lacunate10128963lacunate
laith85722103la_i_th
laity85318903la_i_ty
lalique1644423lalique
lambaste12145013lambaste
lambie103213673lambi__e
lamia75324323lamia__
lamias85020613lamia_s
laminae93512973laminae
laminated122610283laminated
laminates112712903laminates
lamister1037653lamister
lanated8313203la_nated
lancinate1147803lancinate
laniard868523laniard
laniary1068013laniary
lanital7310913lanital
lapidated1345673lapidated
lapidates1247143lapidates
larine63927043lari_ne
larvae938843larva_e
late47560483l___ate
latte55426303la__tte
laurae64011663laura_e
laureate888023laureate
lavage1038263la_vage
lawine93316463lawi_ne
laxity1637273laxi_ty
layette1037133layette
leachate1347443leachate
legate72917453l_egate
lenite6719983leni_te
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
liane54720663l__iane
liberate101113383liberate
librae84310173libra_e
librated113110313librated
librates103412953librates
ligate72519253l_igate
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
lite47054543l__i_te
litigate948303litigate
lobated102610943lob_ated
lobulate1078833lobulate
locate83919843l_ocate
loricate10310663loricate
lubricate1346443lubricate
lucite8313343luci_te
lunate6316043l_unate
luxate1338083l_uxate
lyrate94112103l_yrate
lysate9388103l_ysate
magnate10512703magnate
malate84624553ma_late
maleate94117543maleate
mammate104411273mammate
mandate10315573mandate
marinate103017783marinate
mediate103415213mediate
muriate9313363muriate
narrate7313493narrate
navigate1246073navigate
oblate82214743_oblate
obviate1235783obviate
opiate8513463_opiate
paginate114012443paginate
palate84226783pa_late
paleate94120003paleate
palliate10311893palliate
palmate113215233palmate
palpate113213923palpate
patinate103016313patinate
patriate10311933patriate
placate11312433pla_cate
planate9314573pla_nate
playdate1465263playdate
playmate1566463playmate
rabat72832223rab_at_
rabato83413263rab_ato
rabats83116223rab_ats
rabbinate1345143rabbinate
radiale83813523radiale
radiated102512593radiated
radiates92415293radiates
radicate11412873radicate
ramate83921683ra_mate
ratite65022423rati_te
rebate84424113reb_ate
sabbat10314713sabbat_
sabbath1445393sabbath
sabbats1138633sabbats
sabine84020393sabi_ne
saccate111311763saccate
salivate11310013salivate
samite83020603sami_te
sanitate8612043sanitate
satiated9311603satiated
satiates8314633satiates
savate9313783sa_vate
seriate73722473seriate
sibilate1049533sibilate
slainte738543sla_inte
striate74218953striate
sublate9315363sublate
tabulate10310893tabulate
tannate71813523tannate
taxite13511303taxi_te
tibiae838483tibia_e
trabeate1049483trabeate
tubate82813173tub_ate
vacate11314553va_cate
vaginate123911083vaginate
validate1239003validate
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
variated121211393variated
variates111214983variates
vibrate122811523vibrate
vitiate103412953vitiate

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.406440125.6
2DLD Change Limit1340272586.87619492.0
3Display Results2582580.0932774.2
 (SQL Overall)1786912587.37524229.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.