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

150 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
howled13401497(None) 
bowled125018141bowled
cowled125218391cowled
fowled133914101fowled
holed95634131ho_led
howked177312341howked
howler123514311howler
howlet123518341howlet
jowled174210801jowled
yowled133811091yowled
bawled124415692bawled
behowled1733472behowled
boiled95020952boiled
bolled94722652bolled
bowed114533422bow_ed
boweled132810692boweled
bowleg12369182bowleg
bowler114217312bowler
bowsed125715972bowsed
chowed154914652chow_ed
chowsed16478622chowsed
coaled95022712coaled
coiled95123942coiled
coled85540762co_led
cooled95224592cooled
cowed115637852cow_ed
doiled84817292doiled
doled75430912do_led
dolled83518072dolled
dowed104632612dow_ed
doweled12269772doweled
downed115314782downed
dowsed115015012dowsed
foaled104515962foaled
foiled104618402foiled
fooled104317822fooled
fouled104315972fouled
fowler123712582fowler
goaled85014362goaled
gowned114410132gowned
growled12278172growled
hailed104122742hailed
haled95335822h_aled
hauled104415212hauled
hawed126025422haw_ed
hawked174712672hawked
healed105121442healed
heeled104018422heeled
heiled104415612heiled
helled104024702helled
hewed125619432hew_ed
hilled104022222hilled
hoaxed17378872hoaxed
hobbed144114302hobbed
hobbled153310782hobbled
hoboed124511682hoboed
hocked165521302hocked
hoed87837982ho__ed
hogged125817772hogged
hogweed1534442hogweed
hoised105117432hoised
hoked135326992ho_ked
hold86235062ho_l_d
hole77553392ho_le_
holes84748652ho_les
holey115626902ho_ley
holked144913662holked
hollaed11359852hollaed
holler93520612holler
holloed113812752holloed
homed115425422ho_med
hondled123510652hondled
honed95332262ho_ned
honied104818392honied
honked144517912honked
hooded114616742hooded
hoofed134614892hoofed
hooked145320552hooked
hooped125518182hooped
hooted104422662hooted
hooved134713122hooved
hoped115628182ho_ped
hopped144318112hopped
hoppled15338082hoppled
horded115420482horded
horned105718702horned
horsed105321082horsed
hosed95830982ho_sed
hosted105020342hosted
hotbed123310682hotbed
hotted104319942hotted
housed105624102housed
hoveled14209292hoveled
howdied15296842howdied
howe106734102how_e_
howes114730262how_es
howl107625692howl__
howlers133312352howlers
howlets13329222howlets
howls116219222howl_s
hoyle11314412hoyle_
hoyles12315012hoyles
hulled103920012hulled
hurled104617452hurled
jowed164724422jow_ed
lolled74315822lolled
lowed95233902low_ed
mewled123710052mewled
mobled113213182mobled
moiled94318862moiled
mowed113629012mow_ed
ogled75915962_ogled
oiled64429472_oiled
owed86833872_ow_ed
owlet83324462_owlet
owned95113232_owned
poled84934842po_led
polled94022002polled
pooled94619812pooled
prowled13309912prowled
roiled74320052roiled
rolled74220242rolled
rowed94034322row_ed
roweled11269862roweled
scowled13398192scowled
shawled1437772shawled
shoaled113810972shoaled
shooled115212662shooled
showed135016972show_ed
soiled73822472soiled
soled65835172so_led
souled75419822souled
sowed94933862sow_ed
tholed105113872tho_led
toiled74420322toiled
toled65934922to_led
tolled73819032tolled
tooled74918902tooled
towed95134582tow_ed
toweled112410222toweled
voled95323722vo_led
vowed124424572vow_ed
wawled133811702wawled
whorled14366902whorled
wooled103715502wooled
wowed124023772wow_ed
yawled13459982yawled
yodled11389652yodled
yowed1253025182yow_ed
yowler123310042yowler

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 Filter178691825511.686105985.2
2DLD Change Limit825511506.17313372.9
3Display Results1501500.0463260.9
 (SQL Overall)1786911507.90522604.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.