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

487 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
lioness73910(None) 
bigness1038192bigness
dimness1038842dimness
fitness10299392fitness
glibness1134132glibness
hipness12277382hipness
illness736472illness
laxness1436042laxness
leones64417722leone_s
lianes63819322liane_s
lidless8309272lidless
likeness12229862likeness
liminess10510642liminess
limners93311562limners
limpness1246702limpness
linens64818392li_nens
liners65428852li_ners
lines57054572li_ne_s
linnets739832linnets
lionesses939422lionesses
lionise7310372lionise
lionises8310312lionises
lions55923212lion__s
lipless9259552lipless
liteness82213212liteness
liveness112411392liveness
loess55714702l_o_ess
loners64225812l_oners
looneys10487012looneys
lowness1037812lowness
slimness1036522slimness
witness103010012witness
acidness1136723acidness
agones75719863agone_s
aidless83612073aidless
aimless93610813aimless
airiness8412213airiness
airless73712043airless
algidness1144273algidness
alienees8118653alienees
alieners889823alieners
alienness945373alienness
aligners9117573aligners
alikeness1336333alikeness
aliners74717723ali_ners
alines65735223ali_ne_s
aliveness1238223aliveness
almoners1068133almoners
aloofness1242493aloofness
aptness9268573aptness
aridness939223aridness
atoners75013953atoners
atones65225773atone_s
avidness1246113avidness
axones134614513axone_s
badness1039573badness
baroness101210063baroness
biasness1035813biasness
bibless11439173bibless
biners85023633bi_ners
bines76946793bi_ne_s
biogens1038963biogens
biomass1155993biomass
biomes103815253biome_s
bionics114310873bionics
bionts8612393bion_ts
bizones1837823bizone_s
blindness1235343blindness
blueness1038213blueness
boners84825433_boners
bones76446533_bone_s
boonless10328353boonless
canoness1039393canoness
chicness1535593chicness
cines75239683ci_ne_s
cions75222853cion__s
clines84926043cli_ne_s
cloners94514823cloners
clones84526563clone_s
coiners93620753coiners
cones76457423_cone_s
coneys115218423_coneys
confess12399903_confess
coolness1037743coolness
coyness1277323coyness
crones84729243crone_s
demoness1138053demoness
dienes75719903diene_s
digress938323digress
diners75525953di_ners
dines66449153di_ne_s
dinners83915443dinners
diocese1036853diocese
dioceses1137113dioceses
diodes83915783diode_s
dipnets10109033dipnets
direness9311303direness
donees74519493_donees
droners84114383droners
drones75023433drone_s
dryness11114783dryness
dueness82310123dueness
dulness8307983dulness
dunness8298983dunness
egoless836983egoless
eikones1137853eikone_s
eloiners8128153eloiners
evilness1135043evilness
fairness1136563fairness
farness102912203farness
fatness103311293fatness
fewness1335003fewness
feyness1334923feyness
fineness11310643fineness
fines86644263fi_ne_s
finesse10187643fi_nesse
finest94321733fi_nest
finless102810783finless
firmness1334743firmness
flatness1138153flatness
fluidness1344293fluidness
fulness10248963fulness
gayness1136843gayness
gelidness1144473gelidness
giantess933893giantess
ginners84314223ginners
gladness1036153gladness
glegness1034613glegness
gluiness937363gluiness
glumness1135203glumness
gonefs10439873_gonefs
goners74420173_goners
goodness1036253goodness
gooneys11407073gooneys
grimness1175993grimness
harness102413933harness
highness1536053highness
hipless12399923hipless
hitless103211193hitless
holiness112512503holi_ness
honers94324973_honers
hones88144493_hone_s
honest94822423_honest
honeys124016083_honeys
hotness1038603hotness
iciness938863iciness
icones84616383icone_s
inners63919353_inners
innless7288293_innless
ionics84214483_ionics
ionise63516943_ionise
ionises72916433_ionises
ions46737853_ion__s
ironers74813553ironers
irones64724013irone_s
ironness836953ironness
jitneys17313173jitneys
joiners144211573joiners
jones125028183_jone_s
joneses1438963_joneses
kidneys1533423kidneys
kindness13236653kindness
kines95039133ki_ne_s
kineses113111253ki_neses
kinesis11259593ki_nesis
kinless113310273kinless
kirmess13234313kirmess
koines10415733koine_s
laciness102112553laciness
lameness102612673lameness
lanes54946793l_ane_s
lankness12237043lankness
lanners73618333lanners
largess8408913largess
lateness82614073lateness
lawless1037033lawless
laziness17239983laziness
leaners73718173leaners
leanest7415863leanest
leanness837373leanness
legless838013legless
lenes54738523l_ene_s
lenses64620893l_enses
leone55018823leone__
less45635103l___ess
lewdness1254173lewdness
liaises7311053liaises
lianas63713383lian_as
liane54720663liane__
liangs74410593lian_gs
libbers113812833libbers
libels85112693li_bels
libers84721443li_bers
license9148423license
licenses10118923licenses
lichees123512783lichees
lichens123510683lichens
liches114724293liche_s
licitness1145373licitness
lickers134118253lickers
liefest1038443liefest
lieges74113443liege_s
liens56525503li__ens
liernes739623lierne_s
liers55130403li__ers
lies46454193li__e_s
lieus56218483li__eus
lievest1048343lievest
lifeless11228143lifeless
lifers95617843li_fers
lifters104313773lifters
ligases82310703ligases
ligers75022033li_gers
lightness13107433lightness
lignans8398853lignans
ligneous945233ligneous
lignins84010493lignins
likens105613703li_kens
likers104620913li_kers
likes96231903li_ke_s
likest104914383li_kest
lilies63021413lilie_s
limbers113614743limbers
limbless12246313limbless
limeless10249663limeless
limens84618033li_mens
limes75636503li_me_s
limeys11429273li_meys
limiest93716103limiest
limmers113413083limmers
limned94811473limne_d
limner84112873limne_r
limns75718393limn__s
limonene1044573limonene
limonenes1144983limonenes
limpers113815223limpers
limpest113712313limpest
limpets11329783limpets
linacs8310813li_nacs
lindens839413lindens
line46965573li_ne__
lineal65616023li_neal
linear65113343li_near
lined64934643li_ne_d
lineless82711943lineless
linen55728723li_ne_n
lineny94011443li_neny
liner55938923li_ne_r
lineup835983li_neup
lineups934913li_neups
liney87029633li_ne_y
lingas75116563li_ngas
lingers84223303lingers
lings67135773li_n_gs
liniest73321153liniest
linins65922143li_nins
linkers114317713linkers
links96430193li_n_ks
linnet6419423linne_t
linns56123333li_n_ns
linos55631503li_n_os
lins47059053li_n__s
linsey938993li_nsey
linseys1035083linseys
lintels73311163lintels
linters73822623linters
lintless82710013lintless
lints57137193li_n_ts
linums838283li_nums
lion46334443lion___
lionfish1454093lionfish
lionised946603lionised
lioniser845583lioniser
lionisers944173lionisers
lionize1668823lionize
lionizers1844243lionizers
lionizes1738773lionizes
lipases9209483lipases
lippens11328533lippens
lippers113416433lippers
lippiness1335413lippiness
lisles63416283lisle_s
lispers94514323lispers
listees73416673listees
listels74212433listels
listens74014133listens
listers74026523listers
listless8269263listless
liters65429873li_ters
litheness1247363litheness
lithest10513913lithest
litotes7311183litote_s
litres65220393litre_s
litters73422563litters
liveners11217933liveners
livens94314893li_vens
livers94927823li_vers
lives86133193li_ve_s
livest95315733li_vest
lividness1344713lividness
liviers104211073liviers
livres94311863livre_s
livyers13365903livyers
loaners73913623loaners
lobes75331003l_obe_s
lodens74315063l_odens
lodes66436913l_ode_s
loges66534203l_oge_s
loginess9310163loginess
loins56728423loin__s
loiters74116613loiters
lone45849133l_one__
lonely92912473l_onely
loneness8512093loneness
loner55431043l_one_r
longers84819543l_ongers
longes75925573l_onges
longest84114953l_ongest
longness938553longness
longs65527063l_on_gs
looeys95110123l_ooeys
looies65025833looie_s
lookers114014073lookers
looney94712413loone_y
loonies73919543loonies
looniest83313253looniest
looniness9137573looniness
loons55731723loon__s
loopers93914033loopers
loopiness11136543loopiness
looseness937463looseness
loosens716310953loosens
looses67328243loose_s
loosest75811563loosest
looters74419163looters
lopers84424143l_opers
lopes76437343l_ope_s
lores55045403l_ore_s
lornness836493lornness
losels64714583l_osels
losers65123583l_osers
loses56742013l_ose_s
loss45337963l_o__ss
losses65925233l_osses
lostness837683lostness
loudness937013loudness
louses66230283l_ouses
lovers94223433l_overs
loves85332013l_ove_s
lowers94624923l_owers
lowes85732463l_owe_s
lowest93915593l_owest
loxes125227473l_oxe_s
lucidness1244313lucidness
lunes55337773l_une_s
lunets66914763l_unets
luridness1045193luridness
lushness1136233lushness
madness10310073madness
mildness1136523mildness
milnebs11113793milnebs
miners84126633mi_ners
mines75651953mi_ne_s
mioses84318853miose_s
miriness10310463miriness
moneys115513623_moneys
mooners94015343mooners
moonless10278043moonless
mootness1036753mootness
ness45526563___ness
newness1035703newness
niceness1039843niceness
nighness1236103nighness
nines55937343ni_ne_s
nones55639133_none_s
nonets64118703_nonets
nowness1037033nowness
oddness935313oddness
oiliness8311563oiliness
oldness836403oldness
oneness7512143oneness
ones46146533__one_s
ozones1539393ozone_s
patness92912283patness
peones83821043peone_s
phones114121213phone_s
phoneys15437143phoneys
pines76048863pi_ne_s
pinkness1436513pinkness
pinners93518603pinners
pinones94717073pinone_s
piolets93513193piolets
pioneer936893pioneer
pioneers1035863pioneers
pions75826393pion__s
piousness1147623piousness
pipiness1238003pipiness
pixiness1736093pixiness
plainness1155183plainness
pones74547043_pone_s
poorness1036353poorness
primness1276763primness
prioress1035393prioress
process11310403process
profess1237713profess
prowess1237903prowess
rawness1038153rawness
redness82012443redness
ribless93410343ribless
richness1337433richness
rifeness1138583rifeness
riminess10510093riminess
rimless9369363rimless
rinses64720383ri_nses
rioters73615503rioters
ripeness1039363ripeness
sadness8310613sadness
scones84521303scone_s
shyness1344993shyness
sickness1437833sickness
signees83510803signees
signers84714433signers
signets83311503signets
simnels976103simnels
sines55954823si_ne_s
sinews94210623si_news
sinless73014213sinless
sinners74019023sinners
siziness1737423siziness
slickness1535903slickness
sliminess1137423sliminess
slipless10246993slipless
slitless8268143slitless
slowness1135013slowness
slyness1035263slyness
solidness1036903solidness
sones55444143_sone_s
sonless72612613_sonless
sooners73916643sooners
soonest7415593soonest
stoners74817953stoners
stones65130033stone_s
thinness11277153thinness
tidiness938793tidiness
tieless72512563tieless
tigress836093tigress
tineas64616473ti_neas
tines54848423ti_ne_s
tininess8310633tininess
tinners73717313tinners
tipless92610063tipless
titaness836723titaness
toners64128003_toners
tones56048663_tone_s
trigness968403trigness
trimness1067563trimness
trones65629283trone_s
ugliness936863ugli_ness
vainness1136063vainness
validness13125363validness
vileness1139983vileness
vines85137643vi_ne_s
violets102210003violets
voidness1235553voidness
waeness102512783waeness
wanness102610683wanness
wetness10277723wetness
wideness12259473wideness
wieners103212483wieners
wigless11359673wigless
wildness1236203wildness
wiliness1139113wiliness
wines85546863wi_ne_s
winless103212283winless
winners104316913winners
winoes94317013winoe_s
wiriness1138953wiriness
wiseness112010753wiseness
witless103310983witless
witneys13274723witneys
woeness1020211543woeness
wryness13113983wryness
zinebs17606803zi_nebs
zines145232653zi_ne_s
zipless18276303zipless
zoners155115993_zoners
zones145528043_zone_s

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.1561145455.1
2DLD Change Limit1340274877.36018210.2
3Display Results4874870.1862618.3
 (SQL Overall)1786914877.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.