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

183 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
however163451(None) 
forever1338952forever
hoover124314432ho_over
hover115524132ho__ver
hoverer13319822hoverer
howler123514312how_ler
howsoever1851992howsoever
showerer1436162showerer
soever94412092so_ever
whoever1634102who_ever
whomever1942962whomever
whosever1742892whosever
boneyer1237403boneyer
boweled132810693boweled
bower107328183bow__er
bowered133113043bowered
bowlder13407483bowlder
bowler114217313bow_ler
bowyer14368923bow_yer
chowder16387813chow_der
clever114611533_clever
coherer122912783coherer
cover105430773co__ver
coverer123113523coverer
coveter122912063coveter
cower104531773cow__er
cowered133214653cowered
cowier113616163cow_ier
cozener18328953cozener
dowager1245803dowager
dowdier12328573dowdier
doweled12269773doweled
dower95027703dow__er
dowered122811553dowered
downer104414923dow_ner
downier11299703downier
dowser104716083dow_ser
enfever1344643enfever
ever77027693___ever
fever115617953__fever
flowerer1435453flowerer
forevers1438173forevers
fowler123712583fow_ler
griever1136033griever
haver115124463h__aver
hawker164812663haw_ker
hawser125910843haw_ser
heaver124819673h_eaver
heder95623643h__eder
heeder104216043h_eeder
heeler93917313h_eeler
hewer115719933h__ewer
hexer155116683h__exer
hoarder11329233hoarder
hoarier104211743hoarier
hoarser10388393hoarser
hoaxer16348563ho_axer
hobber134114633ho_bber
hobbler143710403hobbler
hocker155118563ho_cker
hoer76533983ho___er
hogger114615083ho_gger
hogweed1534443hogwe_ed
hoister103714203hoister
hokier134214033ho_kier
holder104619653ho_lder
holdover1544083holdover
holier94921623ho_lier
holler93520613ho_ller
holster103512213holster
homager13107853homager
homelier1338983homelier
homer105828453ho__mer
homered133212713homered
homier116416993ho_mier
honer85332093ho__ner
honester1139713honester
honeyed1437773honeyed
honker134117463ho_nker
honorer1039673honorer
hoodier113812973hoodier
hoofer124014953ho_ofer
hooker134820173ho_oker
hookier143811673hookier
hooper114518313ho_oper
hooter94123933ho_oter
hootier104915353hootier
hooved134713123ho_oved
hoovers134312703ho_overs
hooves124815483ho_oves
hoper105829143ho__per
hopper134218483ho_pper
hoppier143110703hoppier
hornier103012463hornier
horsier103013243horsier
hoser811529763ho__ser
hoseyed1436953hoseyed
hosier94219613ho_sier
hosteler1137273hosteler
hostler103411023hostler
hotelier1137633hotelier
hotter94720083ho_tter
hounder113412233hounder
houser95322283ho_user
hove107132223ho__ve_
hovel115017683ho__vel
hoveled14209293hoveled
hovered143411573hovered
hoverers14289023hoverers
hovers124320253ho__vers
howdie13349733howdie_
howdied15296843howdied
howdies142911953howdies
howe106734103how__e_
howes114730263how__es
howitzer2341913howitzer
howked177312343how_ked
howled134014973how_led
howlers133312353how_lers
howlet123518343how_let
jeweler1735053jeweler
jowlier17327563jowlier
lever85125163__lever
liever94611863_liever
louver94110393lo_uver
lover85526453lo__ver
lower85830413low__er
lowered112711913lowered
lowlier10338903lowlier
modeler1039293modeler
moneyer1237903moneyer
moreover1344863moreover
mover104220863mo__ver
mower104523453mow__er
never86218643__never
obeyer1135893_obeyer
opener83910993_opener
over77227343_o__ver
owner84613313_ow_ner
popover1495843popover
powder123611903pow_der
powderer14245593powderer
power105325953pow__er
powered132911643powered
powter114116033pow_ter
riever94811653_riever
rover85527373ro__ver
rowdier11348593rowdier
roweled11269863roweled
rower85430493row__er
sever85426053__sever
shoveler14165583shoveler
shover124515993sho__ver
shower124315113show__er
showered1537013showered
showerers1545073showerers
showier1339103show_ier
soberer93110353soberer
solver94016703so_lver
sower85229313sow__er
sweer84918573_swe_er
swerver1365733_swerver
sweven1235983_sweven
toweled112410223toweled
tower85729203tow__er
towered112911403towered
towerier1137123towerier
troweler11106063troweler
vower115220793vow__er
waver115025703__waver
weaver123916613__weaver
weber10313523__weber
weer75535093__we_er
weever123811443_weever
whatever1742673whatever
whenever1742773whenever
wherever1743823wherever
whosoever1841983whosoever
wiver115924513__wiver
wolver12419713wo_lver
wowser125110203wow_ser
yodeler1136343yodeler
yowler123310043yow_ler

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 Limit1340271836.73319906.0
3Display Results1831830.0632904.8
 (SQL Overall)1786911837.20224811.3
 
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.