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

335 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
hirsels1012834(None) 
hirsel9138681hirsel_
hirsles101510071hirsles
birses84717732birse_s
chisels12219102chi_sels
diesels8429142diesels
dorsels84412572dorsels
hansels104011652hansels
hassels104311012hassels
herself1337622herself
himself1544282himself
hirees95117292hir_ees
hirers94518062hir_ers
hires86134342hir_e_s
hirples12149642hirples
hirseled12106252hirseled
hirsle9159572hirs_le
hirsled11118112hirsled
hisself1335912hisself
hissers104112312hissers
hisses94719352hisse_s
horses94729342horse_s
hosels94218602h_osels
housels105312132housels
missels94614812missels
morsels94112652morsels
tinsels738372tinsels
ainsell796393ainsell
ainsells895403ainsells
airers64922313air_ers
airless73712043airless
airsheds12274963airsheds
aisles64721143ai_sles
ariels65119373_ariels
arises65233803arise_s
arses55733873_arse_s
artels66216233_artels
barbels114514433barbels
barrels94514363barrels
biases84618433biase_s
birders103913263birders
birlers93813003birlers
birles84920643birle_s
birls74023163bir__ls
birse74517403birse__
bises75435623bi_se_s
bordels103911973bordels
brises84927613brise_s
burses84425513burse_s
carcels114516063carcels
carpels115315463carpels
carrels95117303carrels
carses85233653carse_s
cartels94618123cartels
carvels124914593carvels
charnels13328173charnels
chiels115115933chi__els
chirpers15358133chirpers
chirres123812253chirre_s
chisel112111943chi_sel_
circles1139903circles
cires74932913cir_e_s
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
corses84433463corse_s
corsets94819803corsets
creels84416943_creels
crises84529433crise_s
cursers94317163cursers
curses85328273curse_s
damsels10126703damsels
darnels83710433darnels
diesel74410403diesel_
dieses75218693diese_s
direly10311563dir_ely
dirges84915103dirge_s
dirls64720503dir__ls
dirndls933893dirndls
dispels10310503dispels
disses75225963disse_s
dorsals84110843dorsals
dorsel75315503dorsel_
dorsers83516303dorsers
dossels85511603dossels
drivels11397923drivels
easels65914553_easels
erses55826803_erse_s
fardels11389893fardels
farfels13348213farfels
ferrels10248623ferrels
firers94922683fir_ers
fires85740753fir_e_s
firmers124711443firmers
firstly1335643firstly
firsts95110923firs_ts
frisees104411693frisees
frises94124273frise_s
fusels94412453_fusels
gimels938893gi_mels
girasols984273girasols
girders9379943girders
girdles92210003girdles
girls64518393gir__ls
girosols984653girosols
girshes11248293girshes
gorses74723293gorse_s
gruels73910153_gruels
gunsels8338133gunsels
hairless1157413hairless
hairnets1195633hairnets
hallels103310133hallels
handsels12317243handsels
hansel95214373hansel_
hanses95022633hanse_s
hardens113815023hardens
hareems12428203hareems
harems115513823har_ems
hares86255543har_e_s
harkens144112863harkens
harls85634503har__ls
harmers124116593harmers
harness102413933harness
harpers124916203harpers
harshens1437603harshens
harshly1636273harshly
harslet10315653harslet
harslets1137833harslets
hartals10313023hartals
hassel95614213hassel_
hassles103411693hassles
hausens1077633hausens
hawsers13409483hawsers
hawses125113993hawse_s
hazels185710083h_azels
hearses104414533hearse_s
heels85625533h__eels
heiress1036813heir_ess
heirless1146053heirless
herbals122710603herbals
herders113914123herders
heres86245903her_e_s
herls85226433her__ls
heroes94923823heroe_s
herpes115517323herpe_s
hickeys19508223hickeys
hiders104919653hi_ders
hides95129423hi_de_s
hidroses1237903hidrose_s
hies74842833hi__e_s
higgles123911803higgles
hikers135014353hi_kers
hikes125426983hi_ke_s
hillers103718733hillers
hills85431353hi__lls
hinders113718503hinders
hingers113420213hingers
hinges105121033hinge_s
hinters103719583hinters
hipless12399923hipless
hipness12277383hipness
hipsters13268793hipsters
hirable121612313hirable
hire75538963hir_e__
hired95226263hir_e_d
hiree85427803hir_e_e
hirer85423123hir_e_r
hirple11158973hir_ple
hirpled13157143hirpled
hirseling1396273hirseling
hirselled1344693hirselled
hirsute1084523hirsute
hiss75629213hi_s__s
hissed104114453hisse_d
hisser94713793hisse_r
hissies103915823hissies
hists86328373hi_s_ts
hitless103211193hitless
hitters104717593hitters
hives116925513hi_ve_s
hoarsely1444363hoarsely
hoarsens11306023hoarsens
hoises94823673hoise_s
hordes104921633horde_s
hornets104113553hornets
hornfels1443783hornfels
horse86132653horse__
horsed105321083horse_d
horsefly1744873horsefly
horseless1237213horseless
horsey125115403horse_y
horsily1338843horsily
horstes104516113horstes
horsts95817513hors_ts
hosel86024813h_osel_
hosers95223963h_osers
hoses85443173h_ose_s
hoseys124614003h_oseys
hostels103712313hostels
hotels94515513h_otels
housel95217043housel_
housers104717813housers
houses96032273house_s
hovels125413333h_ovels
hurdles113613373hurdles
hurlers103714323hurlers
hurleys13407333hurleys
hurls86522713hur__ls
hursts97213093hurs_ts
hurters103413643hurters
hurtles103913753hurtles
impels10389523_impels
insets64016133_insets
ires45639283_ir_e_s
irises64221173_irise_s
isles54220563_i_sles
isseis638563_isseis
itself946263_itself
jerseys1733243jerseys
jurels133710583jur_els
kernels11417953kernels
kerseys1433993kerseys
kirmess13234313kirmess
kirtles11309663kirtles
kissers114211293kissers
kisses104217333kisse_s
krises105016083krise_s
libels85112693li_bels
linseys1035083linseys
lintels73311163lintels
lisles63416283li_sles
listels74212433listels
losels64714583_losels
marcels113212373marcels
marses84827113marse_s
marvels123810093marvels
mioses84318853miose_s
mires75640883mir_e_s
misers85025703mi_sers
mises74740563mi_se_s
misrely12319613misrely
missals93914423missals
missel85216523missel_
misses85130873misse_s
missets94516573missets
morels84820013mor_els
morsel85815893morsel_
mussels9419843mussels
nickels13338653nickels
niseis63512023ni_seis
nursers74311833nursers
nurses63919353nurse_s
oriels64914623_oriels
ourself1057453ourself
ousels64815273_ousels
parcels113712663parcels
parrels94713493parrels
parsecs11429923parsecs
parsers94118153parsers
parses85534703parse_s
passels93913023passels
perses85428063perse_s
pissers95014753pissers
pisses84525083pisse_s
pixels15478533pi_xels
prises84133173prise_s
pursers93916093pursers
purses84826373purse_s
reels55333263__reels
ridgels9348023ridgels
riels55121333__riels
rinsers73815743rinsers
rinses64720383rinse_s
risers64624783ri_sers
rises55244043ri_se_s
sarsens7311393sarsens
sels46345983___sels
shiels95418923shi__els
shiksehs1892093shiksehs
shikses14116573shikse_s
shires95225573shir_e_s
shirkers15319583shirkers
shrivels14376443shrivels
simnels976103simnels
sirees64624583sir_ees
sirens65318153sir_ens
sires55945373sir_e_s
sirrees73410573sirrees
sisals63013573si_sals
sises55233833si_se_s
sisses64520603sisse_s
sorels63921163sor_els
sorrels7310723sorrels
streels73811343streels
tarsals72512603tarsals
tassels74510853tassels
teasels74311313teasels
tercels94110363tercels
tersely1038113tersely
theirself1551263theirself
thermels13607763thermels
thirls95012063thir__ls
thirsters1235233thirsters
thirsts1036243thirs_ts
thyrses1335023thyrse_s
tiercels10344733tiercels
tinsel639443tinsel_
tires55437493tir_e_s
tirls54519803tir__ls
torses64727953torse_s
unreels7258313unreels
versers103813523versers
verses94223763verse_s
versets103913103versets
vessels1035933vessels
vireos94212453vir_eos
vires84529683vir_e_s
virls85618603vir__ls
viroses10310533virose_s
viruses1039413viruse_s
vises84427773vi_se_s
warsles103413643warsles
weasels10468503weasels
whimseys19322463whimseys
whirlers14286053whirlers
whirls124710533whir__ls
wirers94617893wir_ers
wires86034913wir_e_s
wisely122711713wi_sely
wises85633193wi_se_s
wisses94619603wisse_s
worsens104610263worsens
worses95522953worse_s
worsets105512843worsets
wurzels1934083wurzels

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.406440125.6
2DLD Change Limit1340273356.93619323.4
3Display Results3353350.1262658.7
 (SQL Overall)1786913357.46823927.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.