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 “kids” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

365 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
kids9602963(None) 
aids57846351aids
bids75838431bids
fids87034731fids
gids65933731gids
ids47535461_ids
kid86540611kid_
kifs116023501kifs
kinds106221811kinds
kins85747901kins
kips106430511kips
kirs85831731kirs
kis78051471ki_s
kiss85227391kiss
kits86441761kits
lids56336451lids
mids76541781mids
rids56539541rids
skids104615321skids
vids85627531vids
yids85224951yids
acids87121002acids
adds67622452adds
ads49755732_ads
aid49269072aid_
aide56044992aide
aides65336602aides
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572ai_s
aits46355532aits
amids85627512amids
ands57833612ands
bads77048862bads
beds75937782beds
bias64738162bias
bibs84830992bibs
bid67751792bid_
bide76041482bide
bides85536772bides
bidi78226572bidi
bidis86721142bidis
bigs76235022bigs
binds86627472binds
bins66548252bins
bios66335322bios
birds85421332birds
bis56860662bi_s
bits66148162bits
bods76244712bods
buds75235172buds
cads76144522cads
caids85226422caids
cigs75625102cigs
cis57748032ci_s
cods76848102cods
cuds76730472cuds
dads67442772dads
dibs76233682dibs
did56850512did_
dido66528192dido
didos76820812didos
didst74619612didst
didy99121502didy
dies55653522dies
difs86027322difs
digs66036052digs
dims75435022dims
dins56652042dins
dips75536912dips
dis46459892di_s
diss56434482diss
dits56450522dits
duds65530142duds
eds46638922_eds
eide55832232eide
eidos65817752eidos
elds56324852elds
ends56528522ends
fads86939872fads
feds85234312feds
fibs96329502fibs
fid76847682fid_
fido87726392fido
fidos95819052fidos
figs85332642figs
fils75838692fils
finds95424822finds
fins75849092fins
firs76637712firs
fits76043462fits
fuds86528562fuds
gads67843382gads
geds66730812geds
gibs75529272gibs
gid57047262gid_
gies55641422gies
gigs66631182gigs
gilds75417522gilds
gins55543952gins
gips75632922gips
girds74816992girds
gits55744592gits
gods65438042gods
grids75321392grids
guids75516152guids
hid76248362hid_
hide85134622hide
hides95129422hides
hies74842832hies
hims95230972hims
hinds96721472hinds
hins76447992hins
hips96433702hips
his66359502hi_s
hiss75629212hiss
hits75545132hits
hods87239862hods
id38941832_id_
ides57734232_ides
ifs67124242_ifs
imids86015142imids
ins35945602_ins
irids66417772irids
is27048212_i_s
its35538832_its
jibs136724082jibs
jigs126524762jigs
jins115635012jins
kaas86531842kaas
kabs107130842kabs
kadi96224822kadi
kadis105921062kadis
kaes85734062kaes
kafs116423742kafs
kaifs125715642kaifs
kails95525212kails
kains96125642kains
kas77058582k_as
kats85944332kats
kays116032192kays
keas86337092keas
kefs115922742kefs
kegs95824012kegs
keirs95313672keirs
kens85435232kens
keps106027302keps
keys116322162keys
khis117017982khis
ki67537952ki__
kibe106523442kibe
kibes115521112kibes
kick96026062kick
kicks104420082kicks
kiddo11398942kiddo
kiddos12416862kiddos
kiddy144910272kiddy
kief117128402kief
kiefs126112202kiefs
kier86526802kier
kiers95320092kiers
kif105941182ki_f
kike76524782kike
kikes85122552kikes
kill85533172kill
kills94526172kills
kiln85620972kiln
kilns95112982kilns
kilo86028662kilo
kilos95021472kilos
kilt86144412kilt
kilts95122182kilts
kin76353962ki_n
kina85631992kina
kinas95626912kinas
kind96128552kind
kine85643422kine
kines95039132kines
king95933652king
kings105825562kings
kink76034392kink
kinks84926082kinks
kino86233612kino
kinos96626142kinos
kiosk836232kiosk
kip97042132ki_p
kir76535672ki_r
kirk76221562kirk
kirks84915262kirks
kirn87123432kirn
kirns95315452kirns
kissy125510312kissy
kist86540792kist
kists95822112kists
kit78559872ki_t
kite85338232kite
kites95432542kites
kith115826352kith
kiths125814972kiths
kiva116516402kiva
kivas124614732kivas
kiwi113211792kiwi
kiwis12328582kiwis
kliks8398822kliks
knits93914742knits
koas85635092koas
kobs105831082kobs
kois85129392kois
kops107031292kops
kors85933012kors
kos76944822k_os
koss85224812koss
kris86423602kris
kudo96115102kudo
kudos105011252kudos
kudu95815422kudu
kudus104910802kudus
kues86426772kues
kvas117015942kvas
kyes115124932kyes
lads56549132lads
libs66732762libs
lid47453512lid_
lido56028152lido
lidos65219882lidos
lies46454192lies
lins47059052lins
lips67141442lips
lis37162272li_s
lits46252492lits
loids66220702loids
mads76845362mads
maids86327142maids
meds75735362meds
mibs85330482mibs
mics87435152mics
mid67354462mid_
midi75628472midi
midis85923412midis
midst85922552midst
migs76935322migs
milds86422052milds
mils66045332mils
minds85427122minds
mips85534082mips
mirs66940572mirs
mis58162622mi_s
miss65339422miss
mods77945052mods
muds75530652muds
nibs65028312nibs
nide55535782nide
nides65229132nides
nidi56524392nidi
nidus65913572nidus
nils46132452nils
nims66226882nims
nips65830922nips
nits45741642nits
nods55838222nods
odds68919922odds
ods47546212_ods
oils46337972oils
olds55926572olds
ouds56430102ouds
oxids13128962oxids
pads76742952pads
peds75835242peds
pias66542552pias
pics85633912pics
pies66949602pies
pigs76634222pigs
pins65558452pins
pips85837132pips
pis56362032pi_s
piss65033332piss
pits66348742pits
pods76540152pods
puds75630512puds
qaids156116312qaids
qis126934382qi_s
quids154917462quids
rads56046602rads
raids65827512raids
reds56042862reds
rias45540592rias
ribs65833022ribs
rid46754622rid_
ride55945122ride
rides66140812rides
rifs74929002rifs
rigs55137592rigs
rims65936302rims
rinds64826142rinds
rins46153192rins
rips66237432rips
rods56442062rods
saids65328852saids
sibs65933542sibs
sics65234092sics
side55444482side
sides65838362sides
sidh86222982sidh
silds65520522silds
sims65737172sims
sins46755272sins
sips65740102sips
sirs44338332sirs
sis37360542si_s
sits45050202sits
skid95720912skid_
skies95026832skies
skims114517182skims
skins94723462skins
skips115616602skips
skis84825282ski_s
skits94721852skits
sods54940212sods
suds56135292suds
tads57143942tads
teds54932572teds
tics65729632tics
tide55237372tide
tides64830152tides
tidy86822412tidy
ties45248312ties
tils45739612tils
tins45251302tins
tips66436762tips
tis37056642ti_s
tits46145032tits
tods56141842tods
urds55922422urds
vid77241802vid_
vide85432752vide
vies75238622vies
vigs85427272vigs
vims95423312vims
vis66747612vi_s
voids95414672voids
wads87343142wads
weds86628932weds
whids125413982whids
wide85235402wide
wides94832822wides
wigs84931252wigs
wilds94818202wilds
winds95425602winds
wins75949172wins
wis66552332wi_s
wiss75630542wiss
wits76044872wits
xis106935332xi_s
yid76640822yid_
yins75335122yins
yips95226692yips
yirds96612512yirds
yods86531182yods
zeds145821802zeds
zigs145422792zigs
zins135735002zins
zips155723792zips
zits136030292zits

Search took 1 second 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 Filter178691298720.0802233637.5
2DLD Change Limit298723650.73340753.1
3Display Results3653650.0963802.1
 (SQL Overall)1786913650.909196579.8
 
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.