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

227 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
kidneys153342(None) 
kidney1434751kidney_
jitneys17313172jitneys
kidders13399162kidders
kidnaps1453322kidnaps
kindness13236652kindness
kines95039132ki_ne_s
ridleys11145782ridleys
witneys13274722witneys
acidness1136723acidness
aiders74524633aid_ers
aides65336603aid_e_s
aidless83612073aidless
aridness939223aridness
avidness1246113avidness
badness1039573badness
barneys12569563barneys
bidders114012303bidders
biders94822803bid_ers
bides85536773bid_e_s
bidets95215533bid_ets
bigness1038193bigness
binders103920743binders
biners85023633bi_ners
bines76946793bi_ne_s
carneys124310543carneys
chimneys1883643chimneys
ciders94620083cid_ers
cinders104617753cinders
cines75239683ci_ne_s
coneys115218423_coneys
deys85027473__d_eys
dickeys17479303dickeys
diddleys14334633diddleys
didies84621833didie_s
didoes85716963didoe_s
dienes75719903diene_s
dimness1038843dimness
diners75525953di_ners
dines66449153di_ne_s
dingeys12458403dingeys
dinkeys15507263dinkeys
dinners83915443dinners
dipnets10109033dipnets
eiders74321363eid_ers
fidges114114383fidge_s
fidgets12388763fidgets
finders113717873finders
fines86644263fi_ne_s
fitness10299393fitness
ginners84314223ginners
gooneys11407073gooneys
gurneys11406463gurneys
hickeys19508223hickeys
hiders104919653hid_ers
hides95129423hid_e_s
hinders113718503hinders
hipness12277383hipness
honeys124016083_honeys
ideas65919013_id_eas
ides57734233_id_e_s
idlers74012813_idlers
idles66720123_idle_s
inners63919353_inners
jitney16304623jitney_
kanes95529373k_ane_s
kedges124812943kedge_s
keeners113610783keeners
kennels11387193kennels
kernels11417953kernels
kernes104717523kerne_s
kerseys1433993kerseys
keys116322163k___eys
kiangs11378363kian_gs
kibbehs18354183kibbehs
kibbes143811193kibbe_s
kibeis12469803ki_beis
kibes115521113ki_be_s
kickers124013293kickers
kidded13299383kidde_d
kidder123811093kidde_r
kiddies133412283kiddies
kiddoes13387063kiddoes
kiddos12416863kid_dos
kiddy144910273kid_dy_
kidnap1334193kidn_ap
kidnapees1651583kidnapees
kidnapers1652463kidnapers
kids96029633kid___s
kidvids1643113kidvids
kiefs126112203ki__efs
kiers95320093ki__ers
kikes85122553ki_ke_s
killers114215573killers
kilned11368393kilne_d
kilns95112983kiln__s
kilters113813593kilters
kinas95626913ki_n_as
kinder113716843kinde_r
kindest12311503kindest
kindlers13318483kindlers
kindles123614843kindles
kindless13289243kindless
kindly14358843kindly_
kindreds14274013kindreds
kinds106221813ki_n_ds
kine85643423ki_ne__
kinema1236013ki_nema
kinemas1336883ki_nemas
kineses113111253ki_neses
kinesis11259593ki_nesis
kings105825563ki_n_gs
kinins104014583ki_nins
kinks84926083ki_n_ks
kinky115816383ki_nky_
kinless113310273kinless
kinos96626143ki_n_os
kins85747903ki_n__s
kippers153211423kippers
kirmess13234313kirmess
kirned11408623kirne_d
kirns95315453kirn__s
kismets13306883kismets
kissers114211293kissers
kisses104217333kisse_s
kiters105218583ki_ters
kites95432543ki_te_s
kithes135016653kithe_s
kittens11347583kittens
knees95114873k__nees
koines10415733koine_s
lianes63819323liane_s
lidless8309273lidless
limeys11429273li_meys
limners93311563limners
lindens839413lindens
linens64818393li_nens
liners65428853li_ners
lines57054573li_ne_s
liney87029633li_ney_
linnets739833linnets
linseys1035083linseys
lioness739103lioness
looneys10487013looneys
madness10310073madness
medleys13115333medleys
mickeys18447943mickeys
middays14335663middays
middens11379373middens
midges103516473midge_s
midgets113910253midgets
midlegs1156323midlegs
midways16386183midways
mildness1136523mildness
milnebs11113793milnebs
minders103720113minders
miners84126633mi_ners
mines75651953mi_ne_s
moneys115513623_moneys
nides65229133nid_e_s
nidgets9358143nidgets
nines55937343ni_ne_s
oddness935313oddness
oldness836403oldness
phoneys15437143phoneys
pigsneys1442003pigsneys
pinders103720473pinders
pines76048863pi_ne_s
piney105727503pi_ney_
pinkeys16378213pinkeys
pinners93518603pinners
redness82012443redness
rickeys16548983rickeys
ridders93612483ridders
riders74123903rid_ers
rides66140813rid_e_s
ridgels9348023ridgels
ridges85817003ridge_s
ridley10169543ridley_
sadness8310613sadness
sawneys13274643sawneys
shinneys14275093shinneys
sides65838363sid_e_s
sidlers83414223sidlers
sidles74721153sidle_s
signees83510803signees
signers84714433signers
signets83311503signets
simnels976103simnels
sines55954823si_ne_s
sinews94210623si_news
sinners74019023sinners
skidders1454813skidders
skidways1942823skidways
skinners12347283skinners
spinneys13335553spinneys
swinneys14264203swinneys
tawneys13324773tawneys
tides64830153tid_e_s
tidiers8389773tidiers
tidies74721833tidie_s
tidiness938793tidiness
tinders84219173tinders
tineas64616473ti_neas
tines54848423ti_ne_s
tinners73717313tinners
videos104911373vid_eos
vines85137643vi_ne_s
voidness1235553voidness
widders123512263widders
wideners12257993wideners
wideness12259473wideness
widens106212723wid_ens
wides94832823wid_e_s
widgets12318453widgets
wieners103212483wieners
wifeys15425873wi_feys
wildness1236203wildness
winceys15395523winceys
winders113721263winders
wines85546863wi_ne_s
winey115325433wi_ney_
winners104316913winners
witness103010013witness
witney12356843witney_
zinebs17606803zi_nebs
zines145232653zi_ne_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.1561145455.1
2DLD Change Limit1340272275.75023309.0
3Display Results2272270.0762986.8
 (SQL Overall)1786912275.98229871.4
 
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.