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

180 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
hurls8652271(None) 
burls74228851burls
churls115411071churls
curls74927101curls
furls85322051furls
harls85634501harls
herls85226431herls
hulls84923561hulls
hurds95219071hurds
hurl76029931hurl_
hurly115819291hurly
hurts86922821hurts
nurls55519681nurls
purls74723351purls
thurls9418711thurls
auras55932552auras
aures55137092aures
auris55331522auris
birls74023162birls
buhls105111802buhls
bulls75629572bulls
buras74736292buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burl64937182burl_
burly104922832burly
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
byrls105711232byrls
carls77037422carls
churl105913882churl_
churns114910232churns
churrs115111512churrs
culls75425812culls
curbs94821652curbs
curds85725612curds
cures75645432cures
curfs105122142curfs
curl66035052curl_
curly105321232curly
curns74924272curns
currs75624392currs
curs65645542cur_s
dirls64720502dirls
duals65620082duals
duels65619232duels
dulls64523742dulls
duras65727722duras
dures65635922dures
durns64819862durns
duros65422692duros
durrs65519992durrs
earls56127512earls
euros54920242euros
farls85731112farls
fuels87117352fuels
fulls84623522fulls
furl77030882furl_
furs76735042fur_s
girls64518392girls
gulls65222982gulls
guls55930852gu_ls
gurus64318192gurus
hails85231642hails
halls85633782halls
hards96435652hards
hares86255542hares
harks126333432harks
harl75740002harl_
harms106829012harms
harps105926862harps
harts88441592harts
hauls86123732hauls
heals85733452heals
heels85625532heels
heils85222192heils
hells85032042hells
herbs105520502herbs
herds96424682herds
heres86245902heres
herl75834552herl_
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872her_s
hills85431352hills
hires86134342hires
hols76946292h_ols
horas86333092horas
horns86125332horns
houris94514562houris
hourly12369622hourly
hours85422382hour_s
howls116219222howls
hubris11218972hubris
hubs96027142hu_bs
hucks144322172hucks
hues75235232hu_es
huffs144514742huffs
hugs86129752hu_gs
hula74923752hu_la
hulas84920882hulas
hulk115321612hu_lk
hulks125715482hulks
hull75428782hu_ll
hullo84417452hullo
hullos94916292hullos
humps126322802humps
hums96831422hu_ms
humus106215072humus
hunks125321452hunks
huns76136932hu_ns
hunts86826172hunts
hurdle103712792hurdle
hurdles113613372hurdles
hurled104617452hurled
hurler94717222hurler
hurlers103714322hurlers
hurley125012522hurley
hurleys13407332hurleys
hurlies103315332hurlies
hurry114917182hurry
hurst85527192hurst
hursts97213092hursts
hurt77142572hur_t
hurtle93512942hurtle
hurtles103913752hurtles
husks125015452husks
huts76737442hu_ts
jarls126120962jarls
jurels133710582jurels
knurls10396242knurls
kurus98015632kurus
lulls54119652lulls
lures56138532lures
lurks95218742lurks
marls75535162marls
merls77423902merls
mulls75124152mulls
murals84016752murals
muras75329562muras
mures75937212mures
murks114821722murks
murrs75521292murrs
nulls55019982nulls
nurds65518522nurds
nurl45327242nurl_
ours47237562our_s
pulls74425052pulls
puls65437562pu_ls
puris75332022puris
purl65631422purl_
purrs75320432purrs
purs65641042pur_s
shorls94516192shorls
shuls85319712shu_ls
suras55336322suras
surds65624662surds
surfs85022542surfs
surly85124422surly
thirls95012062thirls
thurl84912682thurl_
tirls54519802tirls
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
urbs65922052_urbs
urds55922422_urds
urns46323892_urns
urps66920472_urps
urus46426132_urus
virls85618602virls
whirls124710532whirls
whorls124410162whorls
yurts87216532yurts

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 Filter178691538000.1101624463.6
2DLD Change Limit538001801.56334421.0
3Display Results1801800.0463913.0
 (SQL Overall)1786911801.719103950.6
 
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.