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

119 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
pawned12451328(None) 
awned96615951_awned
dawned113912091dawned
fawned134910421fawned
pained95622851pained
paned85437181pa_ned
panned94123431panned
pawed115725611paw_ed
pawnee113115401pawnee
pawner114212921pawner
prawned1346741prawned
spawned13316801spawned
yawned13509841yawned
acned87520672_acned
awed88436032_aw_ed
baned85436352ba_ned
banned94721342banned
barned95623582barned
bawled124415692bawled
caned85838092ca_ned
canned95022062canned
cawed116627062caw_ed
damned104212912damned
darned85018482darned
dawed106222812daw_ed
dawted11489682dawted
downed115314782downed
earned74818332earned
fanned104117472fanned
fawner125910462fawner
gained84617462gained
gawked15468762gawked
gawped13509072gawped
gowned114410132gowned
hawed126025422haw_ed
hawked174712672hawked
impawned1643442impawned
jawed165517372jaw_ed
lawed96028322law_ed
maned86634102ma_ned
manned94418642manned
mawed115824742maw_ed
owned95113232_owned
paced106931682pa_ced
packed154822602packed
padded114113502padded
paged95926782pa_ged
paiked135113432paiked
painted104214632painted
paired95017522paired
paled85538722pa_led
palled94625162palled
palmed114314642palmed
palped114513642palped
pane64950292pa_ne_
panel76023622pa_nel
panes76148692pa_nes
panged104722332panged
panne76623652panne_
panner84224762panner
pannes85522852pannes
panted95024822panted
pared86946762pa_red
parged104922042parged
parked134425142parked
parled94626292parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pashed125923142pashed
passed94320942passed
pasted94426902pasted
pated85237842pa_ted
patined105114782patined
patted94724682patted
paused95114962paused
paved115525262pa_ved
paveed12438892paveed
pawer104422972paw_er
pawn94625302pawn__
pawnees12298172pawnees
pawners124311072pawners
pawnor11357242pawnor
pawns108818132pawn_s
payed115925932pa_yed
peened94318162peened
peined94918842peined
penned94217612penned
phoned124014552phoned
pined85935322p_ined
pinned94818382pinned
plained103812232plained
planed94420912planed
planned103810152planned
prawner1246802prawner
pruned93413112pruned
punned93416192punned
rained75024602rained
sained75424242sained
saned65636272sa_ned
sawed95628402saw_ed
sawney12387602sawney
spanned104111222spanned
spawner12347362spawner
tanned75219952tanned
tawed95926192taw_ed
tawney12338232tawney
tawsed10499742tawsed
vaned94622422va_ned
vanned104614482vanned
waned95831782wa_ned
wanned104318012wanned
warned104018912warned
wawled133811702wawled
yarned105514022yarned
yawed126022452yaw_ed
yawled13459982yawled
yawner12428472yawner
yawped15528102yawped

Search took 4 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.343520965.0
2DLD Change Limit825511192.62331472.0
3Display Results1191190.0333606.1
 (SQL Overall)1786911192.99959583.5
 
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.