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

199 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
hulls8492356(None) 
bulls75629571bulls
culls75425811culls
dulls64523741dulls
fulls84623521fulls
gulls65222981gulls
halls85633781halls
hells85032041hells
hills85431351hills
hulas84920881hulas
hulks125715481hulks
hull75428781hull_
hullo84417451hullo
hullos94916291hullos
hurls86522711hurls
lulls54119651lulls
mulls75124151mulls
nulls55019981nulls
pulls74425051pulls
ahull84010312ahull_
alls46740922_alls
balls76236412balls
bells76432162bells
bills75632862bills
bolls75531312bolls
buhls105111802buhls
bulbs96016932bulbs
bulks115920612bulks
bull65634872bull_
bulla74620562bulla
bully105124812bully
burls74228852burls
calls75634732calls
cells75428062cells
chills114717702chills
churls115411072churls
cull65929642cull_
cullis84115992cullis
cully105520462cully
culms95314192culms
cults75022552cults
curls74927102curls
dells66630942dells
dills65530972dills
dolls66126922dolls
duals65620082duals
duels65619232duels
dull56430442dull_
dully94921632dully
ells46431352_ells
falls85727652falls
fells85327382fells
fills84632372fills
fuels87117352fuels
full75229152full_
fully114820862fully
furls85322052furls
galls64729322galls
ghylls1335142ghylls
gills64728192gills
gules64831042gules
gulfs94915302gulfs
gull54828452gull_
gully94020682gully
gulps84715072gulps
guls55930852gu_ls
hails85231642hails
halals95018312halals
hales85449842hales
hall75741162hall_
hallo85127552hallo
hallos95425102hallos
halms105225212halms
halos85230252halos
halts85230102halts
harls85634502harls
haulms11558502haulms
hauls86123732hauls
heals85733452heals
heels85625532heels
heils85222192heils
hell75637892hell_
hello86522982hello
hellos95321682hellos
helms105619462helms
helos84928062helos
helps105219342helps
herls85226432herls
hill76439492hill_
hillo84721652hillo
hillos94618882hillos
hilly114422162hilly
hilts86924412hilts
hilus84817642hilus
holds94623242holds
holes84748652holes
holks124720562holks
holla84918492holla
hollas94616902hollas
hollo84822162hollo
hollos95320632hollos
holly114824432holly
holms105117802holms
hols76946292h_ols
holts85627912holts
howls116219222howls
hubs96027142hu_bs
hucks144322172hucks
hues75235232hu_es
huffs144514742huffs
hugs86129752hu_gs
hula74923752hu_la
hulk115321612hu_lk
hulky155312472hulky
hulled103920012hulled
huller93919102huller
hullers103616262hullers
hulloa95011182hulloa
hulloas103911912hulloas
hulloes104113922hulloes
hulloo94511732hulloo
hulloos104010072hulloos
humps126322802humps
hums96831422hu_ms
humus106215072humus
hunks125321452hunks
huns76136932hu_ns
hunts86826172hunts
hurds95219072hurds
hurl76029932hurl_
hurly115819292hurly
hurts86922822hurts
husks125015452husks
huts76737442hu_ts
hylas114815902hylas
ills47030422_ills
jells125522162jells
jills125122822jills
kills94526172kills
lalls55324132lalls
lolls512121732lolls
lull44225762lull_
lulus54315162lulus
malls76233432malls
mells75031332mells
mills75435052mills
molls75129782molls
mules75034292mules
mull65128802mull_
mulla74317112mulla
mullas84215932mullas
nills54926672nills
null45125312null_
nurls55519682nurls
palls74332562palls
pills74130972pills
polls74627722polls
pules74538812pules
pulis74225602pulis
pull64731662pull_
pulps95116482pulps
puls65437562pu_ls
purls74723352purls
quells15359692quells
quills153811842quills
quolls15327302quolls
rills55032712rills
rolls55326232rolls
rules55234252rules
sculls84613882sculls
sells55134432sells
shells94319522shells
shills94519602shills
shuls85319712shu_ls
sills55135982sills
skulls10429642skulls
stulls63912972stulls
sulks94818462sulks
sully84622892sully
sulus54821882sulus
talls55133432talls
tells55828942tells
thills95515382thills
thurls9418712thurls
tills54631702tills
tolls54728432tolls
trulls64110282trulls
tules54532792tules
tulle54019932tulle
tulles63218892tulles
ulus45622562_ulus
vills86429322vills
walls85529382walls
wells85426192wells
wills84528962wills
yells85821942yells
yills83921552yills
yules84521582yules
zills144020782zills

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.0931921408.6
2DLD Change Limit538001991.50035866.7
3Display Results1991990.0503980.0
 (SQL Overall)1786911991.643108759.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.