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

196 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
pained9562285(None) 
gained84617461gained
paiked135113431paiked
painted104214631painted
paired95017521paired
paned85437181pa_ned
panned94123431panned
patined105114781patined
pawned124513281pawned
peined94918841peined
pined85935321p_ined
plained103812231plained
rained75024601rained
sained75424241sained
acned87520662_acned
aided75828932_aided
ailed66240282_ailed
aimed85626052_aimed
aired66032922_aired
alined75221402alined
awned96615952_awned
bailed94726652bailed
baited95319242baited
baned85436352ba_ned
banned94721342banned
barned95623582barned
basined10310002basined
brained103816102brained
brined95118412brined
cabined1239992cabined
cairned1037642cairned
caned85838092ca_ned
canned95022062canned
chained133812692chained
chined125620062chined
coined94523602coined
damned104212912damned
darned85018482darned
dawned113912092dawned
dined76431992_dined
drained93713252drained
dwined114610212dwined
earned74818332earned
failed105421602failed
fainer94717242fainer
fainted114211722fainted
faired105915772faired
fanned104117472fanned
fawned134910422fawned
fined94930502_fined
foined105915012foined
gainer74117492gainer
gaited84416922gaited
grained93814272grained
hailed104122742hailed
haired105117172haired
jailed144917422jailed
joined144613072joined
laired75216812laired
lined64934642_lined
mailed95326752mailed
maimed114812662maimed
maned86634092ma_ned
manned94418642manned
mined85333352_mined
nailed74021492nailed
opined95113852opined
paced106931682pa_ced
packed154822602packed
padded114113502padded
paged95926782pa_ged
paid75737482pai__d
pain65647242pain__
painch133511322painch
pains75138282pain_s
paint75443692pain_t
painter93814562painter
paints85921832paints
painty114714752painty
paise75028332paise_
paled85538722pa_led
palled94625162palled
palmed114314642palmed
palped114513642palped
pane64950282pa_ne_
panel76023622pa_nel
panes76148692pa_nes
panged104722332panged
panier84425502panier
panne76623652panne_
panner84224762panner
pannes85522852pannes
panted95024822panted
pared86946762pa_red
parged104922032parged
parked134425132parked
parled94626272parled
parred95024072parred
parsed96323892parsed
parted94228682parted
pashed125923142pashed
passed94320942passed
pasted94426902pasted
pated85237842pa_ted
patinaed11407832patinaed
patine85328122patine_
patines95225762patines
patted94724682patted
paused95114962paused
paved115525262pa_ved
paveed12438892paveed
pawed115725612pa_wed
pawnee113115402pawnee
pawner114212922pawner
payed115925932pa_yed
peened94318152peened
peised94817682peised
penned94217612penned
phoned124014552phoned
pied75035362p_i_ed
piked125623312p_iked
piled85232992p_iled
pine67755712p_ine_
pines76048862p_ines
piney105727502p_iney
pinged104321382p_inged
pinked134819882p_inked
pinned94818382pinned
piped105123162p_iped
plaided11409642plaided
plainer93811982plainer
plaited103713892plaited
planed94420912planed
planned103810152planned
plied85118592pli_ed
plinked143910892plinked
poind84217912poin_d
poinded11358972poinded
pointed103813982pointed
poised94918472poised
ponied94920702ponied
praised104214812praised
prawned1346742prawned
priced115018882priced
prided103618032prided
pried84426862pri_ed
primed115118912primed
prinked143412162prinked
printed104016372printed
prised94322202prised
prized184415392prized
pruned93413112pruned
punned93416192punned
raided85017702raided
railed74727542railed
raised76120332raised
ravined115411822ravined
reined74425522reined
ruined74813322ruined
sailed74327762sailed
sainted84114242sainted
saned65636272sa_ned
seined74023062seined
shined104620782shined
spanned104111222spanned
spavined1434332spavined
spawned13316802spawned
spined95423942spined
splined105013112splined
sprained1138432sprained
stained84215342stained
tailed74424662tailed
tainted83512422tainted
tanned75219952tanned
tined65434532_tined
trained84117202trained
trined74920712trined
twined104413122twined
vailed104619292vailed
vainer93714572vainer
vaned94622422va_ned
vanned104614482vanned
veined104413912veined
vined95626152_vined
waifed134011032waifed
wailed104823592wailed
waired106015832waired
waited103819772waited
waived134511282waived
waned95831782wa_ned
wanned104318012wanned
warned104018912warned
whined134715202whined
wined94434182_wined
yarned105514022yarned
yawned13509842yawned

Search took 10 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.310576422.6
2DLD Change Limit825511968.3609874.5
3Display Results1961960.313626.2
 (SQL Overall)1786911968.98319892.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.