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 “hiss” 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
hiss7562921(None) 
diss56434481diss
hies74842831hies
hims95230971hims
hins76447991hins
hips96433701hips
his66359501hi_s
hisn79620931hisn
hissy116112121hissy
hist76551541hist
hists86328371hists
hits75545131hits
kiss85227391kiss
miss65339411miss
piss65033331piss
wiss75630541wiss
ahis76135382ahi_s
aids57846352aids
ails45654712ails
aims67738182aims
ains46158882ains
airs46447422airs
ais39083572ai_s
aits46355532aits
amiss75823062amiss
ass37844062_ass
bass66146782bass
bias64738152bias
bibs84830972bibs
bids75838422bids
bigs76235012bigs
bins66548242bins
bios66335312bios
bis56860652bi_s
bise66437092bise
bises75435622bises
bisk106523342bisk
bisks115416802bisks
bits66148152bits
bliss75616912bliss
boss65938342boss
briss75824272briss
buss65134912buss
cess65326052cess
chess105016922chess
chias104625512chias
chics123920942chics
chins105631462chins
chips125721252chips
chis95933312chi_s
chits105424572chits
cigs75625102cigs
cis57748032ci_s
cissy104811072cissy
cist67244962cist
cists76624532cists
coss66143492coss
cuss65430612cuss
dibs76233672dibs
dies55653522dies
difs86027322difs
digs66036052digs
dims75435022dims
dins56652042dins
dips75536912dips
dis46459892di_s
disc76123232disc
discs85316262discs
dish86328332dish
disk96625832disk
disks105417472disks
dits56450522dits
doss56235042doss
ess36030882_ess
fess76529162fess
fibs96329492fibs
fids87034732fids
figs85332642figs
fils75838692fils
fins75849092fins
firs76637712firs
fisc96819752fisc
fiscs105311882fiscs
fish106926272fish
fist76248422fist
fists85527542fists
fits76043462fits
foss76431642foss
fuss76027932fuss
ghis85020162ghi_s
gibs75529262gibs
gids65933732gids
gies55641422gies
gigs66631182gigs
gins55543952gins
gips75632922gips
gist56046762gist
gists66026192gists
gits55744592gits
haes77651022haes
hags86740842hags
hahs108333362hahs
haiks125120932haiks
hails85231642hails
hairs86225172hairs
hams96446132hams
haps96443462haps
has67372652h_as
hash106936502hash
hasp96627292hasp
hasps105114642hasps
hast76259482hast
hats76858252hats
haws106439442haws
hays106138072hays
hehs106723962hehs
heils85222192heils
heirs85618562heirs
heist87030912heist
heists96814632heists
hems95534942hems
hens75642572hens
hers75844872hers
hes66654202h_es
hest75950772hest
hests85829932hests
hets75547202hets
hews105631572hews
hi57947582hi__
hic86540562hi_c
hick135530302hick
hicks145322172hicks
hid76248362hi_d
hide85134622hide
hides95129422hides
hie67652702hi_e
hied85434042hied
high116619912high
highs125412522highs
hike116830392hike
hikes125426982hikes
hila76228352hila
hili75626632hili
hill76439492hill
hills85431352hills
hilt75850712hilt
hilts86924412hilts
hilus84817642hilus
him86247652hi_m
hin67559562hi_n
hind85529752hind
hinds96721472hinds
hint77455742hint
hints87330622hints
hip86750432hi_p
hire75538962hire
hires86134342hires
hissed104114452hissed
hisser94713792hisser
hisses94719352hisses
hit66569192hi_t
hive106029672hive
hives116925512hives
hobs97038982hobs
hods87239862hods
hoes75755732hoes
hogs87139662hogs
hoise85224772hoise
hoises94823672hoises
hoist86433212hoist
hoists95516022hoists
hols76946292hols
hons77350782hons
hops97942632hops
hos68364192h_os
hose76547242hose
hoses85443172hoses
host77852832host
hosts85526702hosts
hots78349322hots
hows106345602hows
hoys107733932hoys
hubs96027142hubs
hues75235232hues
hugs86129752hugs
hums96831422hums
huns76136932huns
hush105224112hush
husk116021952husk
husks125015452husks
hussy116812762hussy
huts76737442huts
hyps125418412hyps
ids47535462_ids
ifs67124242_ifs
ins35945602_ins
is27048212_i_s
ism56322382_ism
isms66213472_isms
its35538832_its
jess116022032jess
jibs136724072jibs
jigs126524762jigs
jins115635012jins
jism135514772jism
jisms14458002jisms
joss115925592joss
khis117017982khi_s
kids96029632kids
kifs116023502kifs
kins85747902kins
kips106430512kips
kirs85831732kirs
kis78051472ki_s
kissy125510312kissy
kist86540792kist
kists95822112kists
kits86441762kits
koss85224812koss
lass47444542lass
less45635102less
libs66732752libs
lids56336452lids
lies46454192lies
lins47059052lins
lips67141442lips
lis37162272li_s
lisp68926872lisp
lisps76913902lisps
list47055342list
lists56628692lists
lits46252492lits
loss45337962loss
mass66044932mass
mess65932432mess
mibs85330462mibs
mics87435142mics
mids76541772mids
migs76935312migs
mils66045322mils
mips85534072mips
mirs66940562mirs
mis58162612mi_s
mise66043572mise
mises74740562mises
miso67229892miso
misos76523292misos
missy105617562missy
mist66154522mist
mists76633902mists
moss67641032moss
muss64933762muss
ness45526562ness
nibs65028302nibs
nils46132452nils
nims66226882nims
nips65830922nips
nisi45823242nisi
nisus56014392nisus
nits45741642nits
ohias84415562ohias
oils46337972oils
pass65239952pass
phis95724902phi_s
pias66542552pias
pics85633912pics
pies66949602pies
pigs76634222pigs
pins65558452pins
pips85837132pips
pis56362032pi_s
pish96127912pish
piso66727562piso
pisos76021062pisos
pits66348742pits
priss74623892priss
psis68120342psis
puss64830132puss
qis126934382qi_s
rias45540592rias
ribs65833012ribs
rids56539542rids
rifs74929002rifs
rigs55137592rigs
rims65936302rims
rins46153192rins
rips66237432rips
rise45945232rise
rises55244042rises
risk85724102risk
risks94917062risks
risus54216392risus
sass45035622sass
shies86136552shies
shims104422542shims
shins85131042shins
ships105123772ships
shist84829602shist
shists96515102shists
shits84731162shits
shivs115018802shivs
sibs65933532sibs
sics65234092sics
sims65737172sims
sins46755272sins
sips65740102sips
sirs44338332sirs
sis37360542si_s
sises55233832sises
sissy85812072sissy
sits45050202sits
suss45229302suss
swiss86712902swiss
tass45640572tass
thins85826322thins
this76027382thi_s
tics65729632tics
ties45248312ties
tils45739612tils
tins45251302tins
tips66436762tips
tis37056642ti_s
tits46145032tits
toss45637972toss
vids85627532vids
vies75238622vies
vigs85427272vigs
vims95423312vims
vis66747612vi_s
visa76323872visa
visas84317652visas
vise75632672vise
vises84427772vises
whids125413982whids
whigs125612642whigs
whims134515332whims
whins114922332whins
whips134917082whips
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whisks16497352whisks
whist115322952whist
whists124613812whists
whits115923822whits
wigs84931252wigs
wins75949172wins
wis66552332wi_s
wise75737342wise
wises85633192wises
wish107228732wish
wisp97124072wisp
wisps105214182wisps
wist78049292wist
wists86728522wists
wits76044872wits
wuss75219332wuss
xis106935332xi_s
yids85224952yids
yins75335122yins
yips95226692yips
zigs145422792zigs
zins135735002zins
zips155723792zips
zits136030292zits

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298723651.22024485.2
3Display Results3653650.1562339.7
 (SQL Overall)1786913651.452123065.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.