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

173 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
panned9412343(None) 
banned94721341banned
canned95022061canned
fanned104117471fanned
manned94418641manned
pained95622851pained
paned85437181pa_ned
panged104722331panged
panne76623651panne_
panner84224761panner
pannes85522851pannes
panted95024821panted
pawned124513281pawned
penned94217611penned
pinned94818381pinned
planned103810151planned
punned93416191punned
spanned104111221spanned
tanned75219951tanned
vanned104614481vanned
wanned104318011wanned
acned87520662_acned
annex12310882_annex
anted66328242_anted
awned96615952_awned
banded105223172banded
baned85436352ba_ned
banged104923722banged
banked135021442banked
banner84421502banner
bannet84925332bannet
barned95623582barned
binned94414542binned
branned104311692branned
caned85838092ca_ned
cannel84216402cannel
canner84625982canner
canoed94618952canoed
canted94825782canted
conned95119702conned
damned104212912damned
danced105315252danced
danged94819482danged
darned85018482darned
dawned113912092dawned
denned84215632denned
dinned84317612dinned
donned85015742donned
dunned85015522dunned
earned74818332earned
fanged114318222fanged
fanner94218182fanner
fawned134910422fawned
finned104114602finned
funned103613952funned
gained84617462gained
ganged94619192ganged
gannet74321852gannet
ginned83813982ginned
gunned83513092gunned
handed114919982handed
hanged114222392hanged
hanked144220602hanked
hanted104124312hanted
inned64118422_inned
japanned1843142japanned
kenned114411262kenned
lanced93717722lanced
landed84619242landed
lanner64920592lanner
maned86634092ma_ned
manner84020512manner
paced106931682pa_ced
packed154822602packed
padded114113502padded
paged95926782pa_ged
paiked135113432paiked
painted104214632painted
paired95017522paired
paled85538722pa_led
palled94625162palled
palmed114314642palmed
palped114513642palped
pander93725522pander
pandied113913442pandied
pane64950282pa_ne_
panel76023622pa_nel
paneled10612572paneled
panes76148692pa_nes
pangen94115912pangen
panier84425502panier
panners93621272panners
pannier93613352pannier
panzer174213232panzer
pared86946762pa_red
parged104922032parged
parked134425132parked
parled94626272parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pashed125923142pashed
passed94320942passed
pasted94426902pasted
pated85237842pa_ted
patined105114782patined
patted94724682patted
paused95114962paused
paved115525262pa_ved
paveed12438892paveed
pawed115725612pa_wed
pawnee113115402pawnee
pawner114212922pawner
payed115925932pa_yed
peened94318152peened
peined94918842peined
pended103819012pended
penne75423852penne_
penner84616662penner
phoned124014552phoned
pined85935322p_ined
pinged104321382pinged
pinked134819882pinked
pinner84521492pinner
plained103812232plained
planed94420912planed
planked143512282planked
planner93511622planner
planted103516122planted
ponced114314812ponced
ponded105218772ponded
ponged105619352ponged
ponied94920702ponied
pranced123714042pranced
pranged114512552pranged
pranked143712092pranked
prawned1346742prawned
pruned93413112pruned
punner84918152punner
punnet83518842punnet
punted94618712punted
rained75024602rained
ranged84824312ranged
ranked114620742ranked
ranted74324702ranted
sained75424242sained
sanded84920612sanded
saned65636272sa_ned
scanned104110892scanned
sinned73818412sinned
spanked143111722spanked
spanner94312562spanner
spawned13316802spawned
sunned74216322sunned
swanned11358172swanned
tanged84622492tanged
tanked113919292tanked
tanner63722282tanner
tinned74317532tinned
tunned74014492tunned
vaned94622422va_ned
vanner94215842vanner
waned95831782wa_ned
wanked144517152wanked
wanner94019622wanner
wanted104319722wanted
warned104018912warned
winned104017012winned
wonned104012062wonned
yanked144312242yanked
yarned105514022yarned
yawned13509842yawned
yenned10409382yenned

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.1261418182.5
2DLD Change Limit825511732.73330205.3
3Display Results1731730.0463760.9
 (SQL Overall)1786911732.90561511.5
 
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.