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

158 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
cowled12521838(None) 
bowled125018131bowled
coaled95022701coaled
coiled95123931coiled
coled85540751co_led
cooled95224581cooled
cowed115637841cow_ed
fowled133914091fowled
howled134014961howled
jowled174210791jowled
scowled13398181scowled
yowled133811081yowled
bawled124415692bawled
boiled95020952boiled
bolled94722652bolled
bowed114533422bow_ed
boweled132810692boweled
bowleg12369172bowleg
bowler114217312bowler
bowsed125715972bowsed
cabled114819872cabled
called94126732called
cawed116627062caw_ed
ceiled94114952ceiled
celled94420322celled
chowed154914642chow_ed
chowsed16478602chowsed
clowned13447722clowned
coaler84121702coaler
coated94927032coated
coaxed165612512coaxed
cobbled143411632cobbled
coble94823172coble_
cobles104622882cobles
cocked155022562cocked
cockled163710822cockled
codded114515302codded
coddled123410572coddled
coded95433182co_ded
coed77140542co__ed
coffled16297362coffled
cogged116416612cogged
coifed124113062coifed
coiler84421592coiler
coined94523602coined
coked124730692co_ked
cold77338772co_l_d
cole66956112co_le_
colead94114642co_lead
coles76055062co_les
collet84030362collet
collied103316672collied
combed135516542combed
comped135919872comped
coned86040052co_ned
conked135019112conked
conned95119702conned
cooed84534342co_oed
cooeed95917862cooeed
cooked135921362cooked
cooler84824712cooler
cooped114821602cooped
coped105036842co_ped
copied114618562copied
copped135221252copped
corded105923352corded
cored85044222co_red
corked135020782corked
corned95224522corned
coshed124217542coshed
cosied94819882cosied
costed95623112costed
coted85033852co_ted
could86517712coul_d
coulee8323502coulee
couped115019312couped
coupled124312672coupled
coved115027372co_ved
coward12411672coward
cower104531772cow_er
cowered133214642cowered
cowherd1636952cowherd
cowier113616162cowier
cowl97530812cowl__
cowls106922212cowl_s
cowmen13810922cowmen
cowpea1337642cowpea
cowshed1637772cowshed
coxed154322812co_xed
coyed114623802co_yed
cozied184112152cozied
crawled133710392crawled
crowded14418782crowded
crowed124717292crow_ed
crowned133912422crowned
culled94022472culled
curled95021652curled
cycled1436542cycled
doiled84817292doiled
doled75430912do_led
dolled83518072dolled
dowed104632612dow_ed
doweled12269772doweled
downed115314782downed
dowsed115015012dowsed
foaled104515962foaled
foiled104618402foiled
fooled104317822fooled
fouled104315972fouled
fowler123712582fowler
goaled85014352goaled
gowned114410132gowned
growled12278162growled
holed95634132ho_led
howked177312342howked
howler123514312howler
howlet123518342howlet
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
prowled13309902prowled
roiled74320052roiled
rolled74220242rolled
rowed94034322row_ed
roweled11269862roweled
scowed124413822scow_ed
scowler12248172scowler
soiled73822472soiled
soled65835172so_led
souled75419822souled
sowed94933862sow_ed
toiled74420322toiled
toled65934922to_led
tolled73819032tolled
tooled74918902tooled
towed95134582tow_ed
toweled112410222toweled
voled95323722vo_led
vowed124424572vow_ed
wawled133811702wawled
wooled103715502wooled
wowed124023772wow_ed
yawled13459982yawled
yodled11389642yodled
yowed1253025182yow_ed
yowler123310042yowler

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511582.68630733.8
3Display Results1581580.0463434.8
 (SQL Overall)1786911582.84262875.1
 
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.