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

310 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
labials929987(None) 
labial84714341labial_
bilabials1393652bilabials
cabals104020152cab_als
facials123310742facials
gavials1136602gavials
labels84515682lab_els
labia75219012labia__
labially1336982labially
labiate91313572labiate
labiates101011512labiates
labile8315222labi_le
lamias85020612lamia_s
laminals10339302laminals
lanitals837722lanitals
lariats7615052lariats
radials83614632radials
sabals84618862sab_als
aals49941143_a__als
abas68642083_ab_a_s
abbas95918643_abba_s
abides94719893_abides
abigails1143333_abigails
aerials74017553aerials
ails45654713_a_i_ls
albas75925393alb_a_s
albinal937813albinal_
albinos937653albinos
albites9313203albites
alias55834603_alia_s
amias75831473_amia_s
anils56326723_ani_ls
animals94111703_animals
annals66415923_annals
apicals1159923_apicals
appals104812943_appals
argals75517713_argals
arias55438023_aria_s
ariels65119373_ariels
arils58732203_ari_ls
atabals938413atab_als
avails939693_avails
avians93711563_avians
axial124515193_axial_
axils127217503_axi_ls
baals76122703__baals
babas96325733bab_a_s
babels105216723bab_els
babies106123653babi_es
babkas146010143babka_s
babools11319453babools
babuls105413643bab_uls
bails75933523ba_i_ls
bals66354043__b_als
banians9312033banians
barbitals1345253barbitals
basils85717473basi_ls
biali73419073__biali
bialis83617163__bialis
bialy105119323__bialy
bialys11387913__bialys
bias64738163__bia_s
bilabial1265683bilabial_
bills75632863__bills
birls74023163__birls
bubals103513843bub_als
burials93612083burials
cabal95222153cab_al_
cabala103516913cab_ala
cabalas113516003cab_alas
cabbala1367183cabbala
cabbalas1467373cabbalas
cabins104418923cabi_ns
camails11311753camails
cambial134010763cambial_
canals84421663ca_nals
cantals93919573cantals
capias10318353capia_s
capitals12209443capitals
carpals113414623carpals
casuals91410523casuals
causals91411183causals
caviars1238623caviars
cavils114014393cavi_ls
cobias104014993cobia_s
denials84114133denials
dials64925343__dials
espials937093espials
facial113615633facial_
facias113415803facia_s
fails85631483fa_i_ls
fallals103310193fallals
farfals13268503farfals
faucals12326563faucals
fecials123510333fecials
fetials103711743fetials
finials103210153finials
flails94313003fla_i_ls
gabies93820733gabi_es
gabions102410053gabions
galabias1137733galabia_s
gambias125010733gambia_s
gavial10310083gavial_
gayals1039513ga_yals
gharials1245123gharials
glacial1038143glacial_
habile11515213habi_le
habitans1346623habitans
habitats1346733habitats
habits113014653habi_ts
habitus12338173habitus
hails85231643ha_i_ls
halals95018313ha_lals
hamals114816823ha_mals
hammals14409223hammals
hartals10313023hartals
jabirus1694573jabirus
jacals1539873ja_cals
jackals2036893jackals
jails125422943ja_i_ls
kababs14409773kab_abs
kabala124011553kab_ala
kabalas133911063kab_alas
kabars124513953kab_ars
kabbala1584613kabbala
kabbalas1674353kabbalas
kabikis1243863kabikis
kaiaks937043ka_iaks
kails95525213ka_i_ls
kalians11310183kalians
labara83712893lab_ara
label75019383lab_el_
labella988943labella
labiality1446363labiality
labialize2046713labialize
labializes2145793labializes
labiated11109303labiated
labium10410243labi_um
labors84016413lab_ors
labours9349893labours
labra75415463labra__
labrets939363labrets
labrums1175853labrums
labs67145123lab___s
lacily11612763laci_ly
lacings105013653lacings
lacrimals1342913lacrimals
lactams1136953lactams
lacteals1095663lacteals
ladies75124883ladi_es
ladings93814133ladings
ladinos8389963ladinos
lagans75717783la_gans
lahars94013163la_hars
laical8312323laical_
laichs115110893la_ichs
laics76419253la_i_cs
laighs10508803la_ighs
lairds74711613la_irds
lairs55425873la_i_rs
lakings124713513lakings
lallans74113533lallans
lalls55324133la__lls
lamas75532793la_ma_s
lambdas1246243lambda_s
lambies113015113lambi_es
lambkills1741823lambkills
lamia75324323lamia__
lamiae84817453lamia_e
laminal94113633laminal_
laminas93615873laminas
lampads12477623lampads
lampas106615953lampa_s
lanais6316793la_nais
landaus8310343landaus
laniard868523laniard
laniards967313laniards
laniary1068013laniary
lanital7310913lanital_
laogais845813laogais
lapels83712043la_pels
lapfuls1234503lapfuls
lapides103012043lapides
lapilli945643lapilli
lapillus1043933lapillus
lapins84520683lapi_ns
lapis76223153lapi__s
lapises93513463lapises
lariat6629043laria_t
laris54737463lari__s
larval948503larval_
larvas9310233larva_s
lascars979013lascars
laterals8312753laterals
latices9313763latices
latigos8277243latigos
latilla737953latilla
latillas847363latillas
latinas74416463latinas
latinos73613803latinos
latrias71913213latria_s
lauans65113533la_uans
lauras63414333laura_s
laurels746663laurels
lavas85422223la_va_s
lawines103313563lawines
lawings113611473lawings
layins93817653layi_ns
lazars153812393la_zars
lazies154418783lazi_es
lazily1859713lazi_ly
legals73412733l_egals
lesbians1043603lesbians
lethals1038113lethals
liars54723163l__iars
libels85112693lib_els
liberals1039413liberals
libidos1044653libidos
liblabs1144123liblabs
libras83711703libra_s
locals83714503l_ocals
mafias113913573mafia_s
magians10310753magians
maills84215283ma_ills
mails76037783ma_i_ls
mammals10389273mammals
maniacs114313063maniacs
manias84029033mania_s
manilas93915873manilas
manuals9311213manuals
maximals19325223maximals
medials103914733medials
menials94015683menials
nabis76020583nabi__s
naiads739013na_iads
nails55730403na_i_ls
narial6317953narial_
narwals1036983narwals
nasals63312463na_sals
nasial6413283nasial_
nubias8310093nubia_s
obias76116863_obia_s
orbitals1045713orbitals
pails75833063pa_i_ls
pariahs123812343pariahs
parians93519733parians
parrals94414573parrals
partials101911953partials
pascals11610013pascals
phials1158873_phials
pibals103813083pib_als
playbills1642903playbills
pluvials1343713pluvials
qabala17399193qab_ala
qabalas18289503qab_alas
rabats83116223rab_ats
rabidly1336253rabidly
rabies85226023rabi_es
racial83419243racial_
radial74020393radial_
radiale83813523radiale
radians83013823radians
radicals112610153radicals
raias54631123ra_ia_s
rails55937403ra_i_ls
rascals959663rascals
ratals64219583ra_tals
rebills93510623rebills
redials84416883redials
rials55026673__rials
sabal75422483sab_al_
sabbats1138633sabbats
sabines94318483sabines
sabins85521983sabi_ns
sabirs85414633sabi_rs
sabras85116363sabra_s
sacrals93311793sacrals
sahiwals1443643sahiwals
sails55738103sa_i_ls
salals65120083sa_lals
sambals115213483sambals
samiels939763samiels
sandals82715203sandals
sawbills1344763sawbills
serials73919743serials
sials54227243__sials
socials999633socials
tablas83716163tabla_s
tafias93111963tafia_s
tails55634193ta_i_ls
tamals84116633ta_mals
tarsals72512603tarsals
tibial849843tibial_
tibias839953tibia_s
trials64319883_trials
tribals9610753tribals
uncials92510523uncials
urbias839093urbia_s
urials64415193_urials
vails85825933va_i_ls
vakils1337593vaki_ls
vandals113211663vandals
varias95019903varia_s
vassals1057953vassals
vials85822383__vials
wadmals1335513wadmals
wails86631483wa_i_ls
waxbills2042783waxbills
waybills1643163waybills
zamias174212923zamia_s

Search took 7 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.423422437.4
2DLD Change Limit1340273106.26321399.8
3Display Results3103100.1102818.2
 (SQL Overall)1786913106.79626293.6
 
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.