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

522 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
hirsel913868(None) 
hirsels10128341hirsels
hirsle9159571hirsle
birse74517402birse_
birses84717732birses
chisel112111942chi_sel
diesel74410402diesel
dorsel75315502dorsel
hansel95214372hansel
hassel95614212hassel
herself1337622herself
himself1544272himself
hire75538962hir_e_
hired95226262hir_ed
hiree85427802hir_ee
hirees95117292hirees
hirer85423122hir_er
hires86134342hir_es
hirple11158972hirple
hirseled12106252hirseled
hirsled11118112hirsled
hirsles101510072hirsles
hissed104114452hissed
hisself1335912hisself
hisser94713792hisser
hisses94719352hisses
horse86132652horse_
horsed105321082horsed
horses94729342horses
horsey125115402horsey
hosel86024812h_osel
housel95217042housel
missel85216522missel
morsel85815892morsel
tinsel639442tinsel
ahorse9311513ahorse_
ainsell796393ainsell
aired66032923air_ed
airer54927893air_er
airest63825263airest
airier64619363airier
airmen82612353airmen
airs46447423airs__
airshed11258533airshed
airted74214503airted
aisle55223193ai_sle
ariel55228973_ariel
arise56436433arise_
arisen65316793arisen
arises65233803arises
arse46539273_arse_
arses55733873_arses
artel56122743_artel
barbel104317073barbel
barrel84517873barrel
biased94012223biased
biases84618433biases
birded104414303birded
birder94915493birder
birl65830463bir__l
birle75023633birle_
birled94416993birled
birler85715083birler
birles84920643birles
birred94713203birred
bise66437093bi_se_
bises75435623bi_ses
bordel94514573bordel
brises84927613brises
bursal84414823bursal
burse75527253burse_
burses84425513burses
carcel105018673carcel
carpel105418473carpel
carrel84718633carrel
carse74934333carse_
carses85233653carses
cartel85022533cartel
carvel114817573carvel
charnel124010053charnel
chiel104918973chi__el
chiral114614413chir_al
chirked173810333chirked
chirker16429323chirker
chirmed15379733chirmed
chirped15379783chirped
chirper14359963chirper
chirre114111853chirre_
chirred133612123chirred
chirren12388743chirren
chirres123812253chirres
chisels12219103chi_sels
circle1039703circle
cire65836373cir_e_
cires74932913cir_es
corbel103715973corbel
cormel103815603cormel
cornel84020053cornel
corse75036183corse_
corses84433463corses
corset85636223corset
creel75121483_creel
crises84529433crises
cruel74815903_cruel
curse75829143curse_
cursed94321253cursed
curser84721473curser
curses85328273curses
damsel9148033damsel
darnel74312183darnel
diel59034603di__el
diesels8429143diesels
dieses75218693dieses
dire56644143dir_e_
direly10311553dir_ely
direr64927073dir_er
direst75024243direst
dirge75117073dirge_
dirges84915103dirges
dirked124912273dirked
dirl57430023dir__l
dirled84514903dirled
dirndl834253dirndl
dispel9310323dispel
dissed85220173dissed
disses75225963disses
dorsal74613943dorsal
dorsels84412573dorsels
dorser74819173dorser
dossel74813643dossel
drivel105110383drivel
easel54521113_easel
erses55826803_erses
fardel104712593fardel
farfel124310433farfel
ferrel92810203ferrel
fire76245593fir_e_
fired94829743fir_ed
firer811229253fir_er
fires85740753fir_es
firmed125411883firmed
firmer114712443firmer
firs76637713firs__
first86226123firs_t
firstly1335643firstly
firsts95110923firsts
frise85322453frise_
frisee94217993frisee
frises94124273frises
fusel85218493_fusel
gimel8313353gi_mel
girasol874623girasol
girded93712493girded
girder84312063girder
girdle82110463girdle
girl56226553gir__l
girned84010513girned
girosol885303girosol
girsh95310023girs_h
girshes11248293girshes
girted83912873girted
gorse65926813gorse_
gorses74723293gorses
gruel66014743_gruel
gunsel7339853gunsel
haired105117173hair_ed
hairier103111053hairier
hairnet10911703hairnet
hairs86225173hairs__
hallel93514093hallel
handsel11308723handsel
hanse85722793hanse_
hansels104011653hansels
hanses95022633hanses
harden105718533harden
harder105022403harder
hardset113415833hardset
hare76255733har_e_
hared95742183har_ed
hareem114312063hareem
harem104924453har_em
hares86255543har_es
harked145422553harked
harken135116343harken
harl75740003har__l
harmed125218833harmed
harmer114719553harmer
harped124418403harped
harper115018403harper
harsh116418053hars_h
harshen1339283harshen
harsher13310363harsher
harshly1636273harshly
harslet10315653harslet
hartal9415473hartal
hassels104311013hassels
hassle93711593hassle
hausen9610383hausen
hawse116015123hawse_
hawser125910843hawser
hawses125113993hawses
hazel176414813h_azel
hearse94114273hearse_
hearsed113811403hearsed
hearses104414533hearses
heel75034223h__eel
heired103813043heir_ed
heiress1036813heiress
heirs85618563heirs__
herbal112513493herbal
herbed123513453herbed
herded114215643herded
herder104516463herder
here76447103her_e_
heres86245903her_es
heresy125011233heresy
herl75834553her__l
heroes94923823heroes
herpes115517323herpes
hers75844873hers__
hiatal9310193hiatal
hickey185011993hickey
hidden11429743hidden
hide85134623hi_de_
hided105222443hi_ded
hider95024083hi_der
hides95129423hi_des
hidroses1237903hidroses
hie67652703hi__e_
hied85434043hi__ed
hiemal11339493hiemal
hies74842833hi__es
higgle113811743higgle
higher134610893higher
hike116830393hi_ke_
hiked135919203hi_ked
hiker125119393hi_ker
hikes125426983hi_kes
hill76439493hi__ll
hilled104022223hilled
hiller94421633hiller
hilted104016043hilted
hims95230973hims__
hinder104120063hinder
hinge95323443hinge_
hinged114618913hinged
hinger104723313hinger
hinges105121023hinges
hins76447993hins__
hinted104318323hinted
hinter94021303hinter
hipped144317693hipped
hipper133818023hipper
hips96433703hips__
hipster12288783hipster
hirable121612313hirable
hirers94518063hirers
hiring104421603hiring
hirpled13157133hirpled
hirples12149643hirples
hirseling1396273hirseling
hirselled1344683hirselled
hirsute1084523hirsute
his66359503hi_s__
hisn79620933hi_s_n
hiss75629213hi_s_s
hissers104112313hissers
hissier103410503hissier
hissies103915823hissies
hissy116112123hi_ssy
hist76551543hi_s_t
histed104420243histed
hists86328373hi_sts
hither124417253hither
hitmen11239193hitmen
hits75545133hits__
hitter94419863hitter
hive106029673hi_ve_
hived125217913hi_ved
hives116925513hi_ves
hoarse94411323hoarse_
hoarsely1444363hoarsely
hoarsen10367993hoarsen
hoarser10388393hoarser
hoise85224773hoise_
hoised105117433hoised
hoises94823673hoises
horal86328673hor_al
horde94623053horde_
horded115420483horded
hordes104921633hordes
horned105718703horned
hornet94926433hornet
horsefly1744873horsefly
horsier103013243horsier
horsily1338843horsily
horst85833513hors_t
horste94817413horste
horstes104516113horstes
horsts95817513horsts
horsy116318393hors_y
hose76547243h_ose_
hosed95830983h_osed
hosels94218603h_osels
hosen85623883h_osen
hoser811529763h_oser
hoses85443173h_oses
hosey116127023h_osey
hostel93914153hostel
hotel85520743h_otel
house89131423house_
housed105624103housed
housels105312133housels
houser95322283houser
houses96032273houses
hovel115017683h_ovel
hurdle103712793hurdle
hurl76029933hur__l
hurled104617453hurled
hurler94717223hurler
hurley125012523hurley
hurst85527193hurs_t
hursts97213093hursts
hurter93915853hurter
hurtle93512943hurtle
impel95711763_impel
inset54430863_inset
ire36943173_ir_e_
ired55131873_ir_ed
ires45639283_ir_es
irised73913153_irised
irises64221173_irises
irked104510923_irked
irreal657823_irreal
isle45121703_i_sle
issei568573_issei
itself946253_itself
jersey1636333jersey
jurel124516333jur_el
kernel104010583kernel
kersey1336783kersey
kirned11408623kirned
kirs85831733kirs__
kirsch1532713kirsch
kirtle10309473kirtle
kissed114412853kissed
kisser104212453kisser
kisses104217333kisses
kittel10368863kittel
krises105016083krises
libel74116103li_bel
linsey938983linsey
lintel64013993lintel
lire47845293lir_e_
lisle53916723li_sle
listel64214733listel
losel54419423_losel
marcel103714853marcel
marse76231153marse_
marses84827113marses
marvel113712003marvel
mioses84318853mioses
mire66748223mir_e_
mired85729223mir_ed
mires75640883mir_es
mirex146816623mir_ex
mirier83918353mirier
mirker123712693mirker
mirs66940563mirs__
mise66043573mi_se_
miser75430403mi_ser
mises74740563mi_ses
misrely12319603misrely
missal84314903missal
missed94423603missed
missels94614813missels
misses85130873misses
misset85028153misset
morel75729093mor_el
morse76032703morse_
morsels94112653morsels
mussel83412903mussel
nickel123811343nickel
nisei54214353ni_sei
nurse54420123nurse_
nursed74514663nursed
nurser64314503nurser
nurses63919353nurses
oriel54920423_oriel
ourself1057453ourself
ousel55222403_ousel
parcel103915473parcel
parrel84515983parrel
parse75236993parse_
parsec105914473parsec
parsed96323893parsed
parser84822373parser
parses85534703parses
passel85117003passel
perse75429523perse_
perses85428063perses
pissed94816933pissed
pisser84416383pisser
pisses84525083pisses
pixel143911903pi_xel
prise74632613prise_
prised94322203prised
prises84133173prises
purse76028893purse_
pursed95220883pursed
purser85020473purser
purses84826373purses
reel45240533__reel
ridgel8399963ridgel
riel46432383__riel
rinse54820973rinse_
rinsed75016353rinsed
rinser64317213rinser
rinses64720383rinses
rise45945233ri_se_
risen54621883ri_sen
riser55431053ri_ser
rises55244043ri_ses
sarsen6314233sarsen
sel38253323___sel
shiel811023773shi__el
shikse1386073shikse_
shikseh17102603shikseh
shikses14116573shikses
shire84727133shir_e_
shires95225573shir_es
shirked153710463shirked
shirker143711343shirker
shirred113710493shirred
shrivel13479403shrivel
simnel857023simnel
sire46150413sir_e_
sired66134283sir_ed
siree55238813sir_ee
sirees64624583sirees
siren54525823sir_en
sires55945373sir_es
sirree64017333sirree
sirs44338333sirs__
sisal54217733si_sal
sises55233833si_ses
sisses64520603sisses
sorel56231443sor_el
sorrel6413543sorrel
streel64214023streel
tarsal63315273tarsal
tassel66014773tassel
teasel63914983teasel
tercel83612993tercel
terse55026823terse_
tersely1038103tersely
terser67317823terser
theirself1551263theirself
thermel12569893thermel
thirl85416823thir__l
thirled11328093thirled
thirst9312253thirs_t
thirsted1235213thirsted
thirster1135673thirster
thirsts1036243thirsts
thirsty1354083thirsty
thyrse1235133thyrse_
thyrses1335013thyrses
tiercel9316203tiercel
tinsels738373tinsels
tire46143353tir_e_
tired65228903tir_ed
tires55437493tir_es
tirl45029923tir__l
tirled74714363tirled
torse55833333torse_
torses64727953torses
unreel63612933unreel
versal93013753versal
verse84723583verse_
versed104515513versed
verser94516963verser
verses94223763verses
verset94327323verset
vessel937953vessel
viral86419593vir_al
vireo84816453vir_eo
vires84529683vir_es
virile9313433virile
virl76224473vir__l
viroses10310533viroses
viruses1039413viruses
vise75632673vi_se_
vised95518763vi_sed
vises84427773vi_ses
warsle93112923warsle
weasel93410523weasel
whimsey18373893whimsey
whirl114913823whir__l
whirled14368043whirled
whirler13307603whirler
whirred14386933whirred
whirs115218093whirs__
wire75839813wir_e_
wired95327643wir_ed
wirer85124953wir_er
wires86034913wir_es
wirier94215553wirier
wise75737343wi_se_
wised95123343wi_sed
wisely122711713wi_sely
wiser85522803wi_ser
wises85633193wi_ses
wissed104114643wissed
wisses94619603wisses
worse86525263worse_
worsen95513873worsen
worser95117523worser
worses95522953worses
worset96726583worset
wurzel1834993wurzel
yirred10426963yirred

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165226.25018034.6
3Display Results5225220.1733017.3
 (SQL Overall)1786915226.56327227.0
 
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.