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

313 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
fined9493050(None) 
dined76431991dined
fiend95312981fiend
fifed125115971fifed
filed95331901filed
find87532601fin_d
fine75147951fine_
finer85431561finer
fines86644261fines
finked144214621finked
finned104114601finned
fired94829741fired
fixed165416951fixed
foined105915011foined
lined64934641lined
mined85333351mined
pined85935321pined
tined65434531tined
vined95626151vined
wined94434181wined
acned87520662acned
affined1436412affined
aided75828932aided
ailed66240282ailed
aimed85626052aimed
aired66032922aired
alined75221402alined
awned96615952awned
baned85436352baned
bided95424962bided
biked125320032biked
bind76234512bin_d
bine66650862bine_
biner75930692biner
bines76946792bines
binged105920822binged
binned94414542binned
biped104718832biped
boned85133242boned
brined95118412brined
caned85838092caned
chined125620062chined
cine66242942cine_
cines75239682cines
cited84421952cited
coined94523602coined
coned86040052coned
defined123813822defined
diced95824682diced
died66137852di_ed
diked115024682diked
dine55555332dine_
diner65632902diner
dines66449152dines
dinged95221782dinged
dinked124818352dinked
dinned84317612dinned
dinted84419842dinted
dived106321372dived
dwined114610212dwined
faced117727652faced
faded105025242faded
failed105421602failed
fainer94717242fainer
fainted114211722fainted
faired105915772faired
faked135225482faked
famed115928342famed
fane75343562fane_
fanes84639892fanes
fanged114318222fanged
fanned104117472fanned
fared95842342fared
fated95632132fated
fawned134910422fawned
faxed166220532faxed
fayed126422152fayed
fazed186222962fazed
fed76548352f__ed
feed84538902f_eed
feigned1245352feigned
feinted11379622feinted
fenced124412712fenced
fend84832972fen_d
fended114216912fended
feted94420932feted
feued94715662feued
fibbed144011552fibbed
fiber104921132fiber
fice95737112fice_
fices106031162fices
fid76847682fi__d
fidged124610922fidged
fie67152442fi_e_
fief107331362fi_ef
field95015322field
fiends104110292fiends
fife106027702fife_
fifer115519972fifer
fifes114822392fifes
figged124013892figged
file75446642file_
filer85433002filer
files85441272files
filet85540162filet
filled104922262filled
filmed124610362filmed
fin66458032fin__
final83922032final
finca104714502finca
finch135416972finch
finder104020232finder
finds95424822finds
finely123011562finely
finery124512892finery
finest94321732finest
finger104920332finger
finis86824262finis
fink117532122fin_k
finks125424222finks
finny114716752finny
fino76034692fin_o
finos86226952finos
fins75849092fin_s
fiord94313342fiord
fire76245592fire_
firer811229252firer
fires85740752fires
firmed125411882firmed
fished134316312fished
fisted104218702fisted
fitted104716662fitted
five107629742five_
fiver116024942fiver
fives116027362fives
fixer154717832fixer
fixes154723592fixes
fizzed18369442fizzed
fled85429772f_led
flied96519432flied
flinted114411892flinted
flited104616582flited
flued95021252flued
foiled104618402foiled
fond86330952fon_d
fonded115717042fonded
foxed165115212foxed
freed95223542freed
fried95322912fried
friend10388932friend
fringed123611522fringed
frized193510682frized
fumed116118822fumed
fund85624982fun_d
funded114413892funded
funked144214112funked
funned103613952funned
fused94820442fused
fuzed185415252fuzed
gained84617462gained
gibed96215962gibed
gied64631982gi_ed
ginned83813982ginned
girned84010512girned
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hind85529752hin_d
hinged114618912hinged
hinted104318322hinted
hired95226262hired
hived125217912hived
honed95332262honed
iced78721892_iced
inked104218522_inked
inned64118422inned
ired55131872_ired
jibed155114162jibed
jinked184013142jinked
jinxed21346082jinxed
jived165115042jived
joined144613072joined
kilned11368392kilned
kind96128552kin_d
kine85643422kine_
kines95039132kines
kinged124215282kinged
kinked104014752kinked
kirned11408622kirned
kited105120092kited
lied55838092li_ed
liked104523812liked
limed85426802limed
limned94811472limned
line46965572line_
linen55728722linen
liner55938922liner
lines57054572lines
liney87029632liney
linked114518212linked
linted74021822linted
lived95523722lived
maned86634092maned
miked125020452miked
mimed105622732mimed
minced114114912minced
mind75434372min_d
minded103817832minded
mine67256162mine_
miner76933542miner
mines75651952mines
minted94220582minted
mired85729222mired
mixed155717252mixed
nided75920872nided
nine45842172nine_
nines55937342nines
nixed135714222nixed
oiled64429472oiled
oinked114213282oinked
opined95113852opined
owned95113232owned
pained95622852pained
paned85437182paned
peined94918842peined
pied75035362pi_ed
piked125623312piked
piled85232992piled
pine67755712pine_
pines76048862pines
piney105727502piney
pinged104321382pinged
pinked134819882pinked
pinned94818382pinned
piped105123162piped
rained75024602rained
refined114720002refined
reined74425522reined
riced85825542riced
riled65833252riled
rimed84826372rimed
rind56535602rin_d
rinded84418982rinded
ringed84623842ringed
rinsed75016352rinsed
riped85226432riped
rived94825612rived
ruined74813322ruined
sained75424242sained
saned65636272saned
seined74023062seined
shined104620782shined
sided74825952sided
signed83413752signed
sine46560622sine_
sines55954822sines
sinew84718922sinew
singed85422292singed
sinned73818412sinned
siped84927682siped
sired66134282sired
sited65130742sited
sized155519242sized
sned56026052_sned
spined95423942spined
tided76322512tided
tied55535212ti_ed
tiled64832942tiled
timed85223612timed
tine45855132tine_
tinea54923152tinea
tineid74412012tineid
tines54848422tines
tinged84220792tinged
tinned74317532tinned
tinted74419532tinted
tired65228902tired
toned65435342toned
trined74920712trined
tuned64622312tuned
twined104413122twined
tyned95915012tyned
vaned94622422vaned
veined104413912veined
viced115118182viced
vied86328632vi_ed
vine75643682vine_
vines85137642vines
vised95518762vised
waned95831782waned
whined134715202whined
wifed125117742wifed
wiled95231552wiled
winced124415342winced
wind85533852win_d
winded114918212winded
wine74953422wine_
wines85546862wines
winey115325432winey
winged114620832winged
winked144018602winked
winned104017012winned
wiped114722082wiped
wired95327642wired
wised95123342wised
wited94727142wited
wived125121502wived
zinced18419412zinced
zine137036152zine_
zineb165614142zineb
zines145232652zines
zinged174414622zinged
zoned154020262zoned

Search took 5 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 Filter178691538000.453394461.4
2DLD Change Limit538003133.64014780.2
3Display Results3133130.1901647.4
 (SQL Overall)1786913134.28341721.0
 
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.