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

325 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
miner7693354(None) 
biner75930691biner
diner65632901diner
finer85431561finer
liner55938911liner
miler75733061miler
mimer94825761mimer
mincer104017361mincer
minder94822501minder
mine67256151mine_
mined85333351mined
miners84126631miners
mines75651951mines
minor74920061minor
minter84425101minter
miser75430401miser
miter75734791miter
mixer145017641mixer
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
aliner65621982aliner
amine75835372amine_
amines84727982amines
bider85728372bider
bier65531822bi_er
biker116022562biker
binder94422872binder
bine66650852bine_
biners85023632biners
bines76946792bines
binger94923442binger
biter75030032biter
boner75133082boner
briner84519042briner
caner75334772caner
cider84723312cider
cinder94119122cinder
cine66242942cine_
cines75239682cines
citer74827322citer
coiner84323782coiner
dicer85426422dicer
diker105524552diker
dimer85625602dimer
dinar66319892dinar
dine55555332dine_
dined76431992dined
dinero75612642dinero
diners75525952diners
dines66449152dines
dinger85323662dinger
dinner74217152dinner
direr64927072direr
diver94827802diver
eider64624742eider
fainer94717242fainer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finder104020232finder
fine75147952fine_
fined94930502fined
finery124512882finery
fines86644262fines
finger104920322finger
firer811229252firer
fiver116024942fiver
fixer154717832fixer
gainer74117492gainer
giber85417702giber
ginger84920022ginger
ginner73915812ginner
giver94921202giver
goner66025152goner
hider95024082hider
hiker125119392hiker
hinder104120062hinder
hinger104723312hinger
hinter94021302hinter
hirer85423122hirer
honer85332092honer
imine75821042imine_
imines84918342imines
inert53234372_inert
infer84215032_infer
inker94421092_inker
inner54920622inner
inter55028492_inter
jiber145115702jiber
jinker174013542jinker
jiver155119052jiver
joiner134114132joiner
kier86526802ki_er
kinder113716842kinder
kine85643422kine_
kines95039132kines
kiter95523212kiter
liber74723612liber
lier45942462li_er
lifer85822152lifer
liger65024462liger
liker95627062liker
limner84112862limner
line46965572line_
linear65113332linear
lined64934642lined
linen55728722linen
liners65428842liners
lines57054572lines
liney87029622liney
linger75225992linger
linier64423782linier
linker104321462linker
linter64625332linter
liter54736342liter
liver85132962liver
loner55431032loner
macer912126942macer
mailer84724182mailer
maimer104514592maimer
maker114127812maker
mane65052012mane_
maned86634092maned
manes76648952manes
manger94325002manger
manner84020512manner
manor78023922manor
mariner93315992mariner
maser75029972maser
mater74438862mater
mazer165722422mazer
meaner84617842meaner
mender93520792mender
merer75126232merer
meter75130322meter
mice87442222mice_
mien65028352mi_en
miens76118302miens
mike105535282mike_
miked125020452miked
mikes115129892mikes
milder93818452milder
mile66352562mile_
milers84625162milers
miles74645072miles
milker124814322milker
miller84625412miller
milneb1095952milneb
milter84921232milter
mime85736392mime_
mimed105622732mimed
mimeo96018682mimeo
mimers105520182mimers
mimes95732022mimes
mina65136902min_a
minae75627722minae
minas75434112minas
mince95325232mince
minced114114912minced
mincers113714842mincers
minces104420802minces
mincier113512462mincier
mincy125817412mincy
mind75434362min_d
minded103817832minded
minders103720112minders
minds85427122minds
mineral9312732mineral
mingier103815282mingier
mingler104213832mingler
mingy115520182mingy
mini65634542min_i
minim97321592minim
minis75432982minis
miniver1238392miniver
mink106636512min_k
minke115421762minke
minkes124618782minkes
minks115829272minks
minny104518662minny
minors85117092minors
minster93914322minster
mint66758042min_t
minted94220582minted
minters93822462minters
mintier93615992mintier
mints76834042mints
minty106323902minty
minuet82621032minuet
minus75223932minus
minuter93510402minuter
minx137723332min_x
minxes154612982minxes
mir57046762mi__r
mire66748222mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918352mirier
mirker123712692mirker
mise66043572mise_
misers85025702misers
misery114113542misery
mises74740562mises
mister84728562mister
mite66249402mite_
miters84328772miters
mites75141802mites
mither114218562mither
mitier83620662mitier
mitre75522422mitre
mixed155717252mixed
mixers154513562mixers
mixes147224402mixes
mizen164815272mizen
moaner84415112moaner
moiler84017262moiler
money104826842money
monger94418332monger
mooner85317832mooner
moper94925922moper
mover104220862mover
mower104523452mower
muser76024122muser
muter74525542muter
nicer74618292nicer
nine45842172nine_
nines55937342nines
niter55028972niter
oiler54628282oiler
owner84613312owner
pier66035292pi_er
piker115622842piker
pincer104019172pincer
pinder94523452pinder
pine67755712pine_
pined85935322pined
pinery115214282pinery
pines76048862pines
piney105727502piney
pinger94324082pinger
pinier84024692pinier
pinker125322442pinker
pinner84521492pinner
piper96523192piper
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
ringer74526052ringer
rinser64317212rinser
riper74328402riper
riser55431052riser
river85731692river
ruiner64013642ruiner
saner54334322saner
seiner64622482seiner
shiner93820872shiner
signer74015622signer
siker95326032siker
sine46560622sine_
sines55954822sines
sinew84718922sinew
singer74227302singer
sinker103620902sinker
sinner64320592sinner
sinter63625922sinter
siver85728612siver
sizer145521812sizer
smiler83916682smiler
smiter83616412smiter
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinder73821802tinder
tine45855132tine_
tinea54923152tinea
tined65434532tined
tines54848422tines
tinier63622232tinier
tinker103619922tinker
tinner64119952tinner
tinter63923642tinter
titer55430612titer
toner55336242toner
tuner56022682tuner
twiner94012592twiner
vainer93714572vainer
veiner94514752veiner
vier75428152vi_er
viler86324162viler
vine75643682vine_
vined95626152vined
vinery124912592vinery
vines85137642vines
vinier93716742vinier
viper105017302viper
weiner94214132weiner
whiner124516632whiner
wider94826352wider
wiener94513542wiener
wincer115018192wincer
winder104025262winder
wine74953422wine_
wined94434182wined
winery125014272winery
wines85546862wines
winey115325432winey
winger104125432winger
winier94522452winier
winker134220292winker
winner94219922winner
winter94222802winter
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
zine137036152zine_
zineb165614142zineb
zines145232652zines
zinger163816692zinger
zoner144520342zoner

Search took 2 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.0931921408.6
2DLD Change Limit538003251.62633087.3
3Display Results3253250.0764276.3
 (SQL Overall)1786913251.79599549.3
 
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.