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

304 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
finer8543156(None) 
biner75930691biner
diner65632901diner
fainer94717241fainer
fiber104921131fiber
fifer115519971fifer
filer85433001filer
finder104020231finder
fine75147951fine_
fined94930501fined
finery124512891finery
fines86644261fines
finger104920331finger
firer811229251firer
fiver116024941fiver
fixer154717831fixer
liner55938921liner
miner76933541miner
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
aliner65621982aliner
bider85728372bider
bier65531832bi_er
biker116022562biker
binder94422872binder
bine66650862bine_
biners85023632biners
bines76946792bines
binger94923452binger
biter75030032biter
boner75133082boner
briner84519042briner
caner75334772caner
cider84723312cider
cinder94119122cinder
cine66242942cine_
cines75239682cines
citer74827332citer
coiner84323782coiner
definer114413772definer
dicer85426422dicer
diker105524552diker
dimer85625602dimer
dinar66319892dinar
dine55555332dine_
dined76431992dined
dinero75612642dinero
diners75525952diners
dines66449152dines
dinger85323672dinger
dinner74217162dinner
direr64927072direr
diver94827802diver
eider64624742eider
facer105525052facer
fader94421512fader
fainter103611052fainter
fairer95212062fairer
faker124824592faker
fane75343572fane_
fanes84639892fanes
fanner94218182fanner
farer86733142farer
fawner125910462fawner
feigner1135592feigner
fencer114613532fencer
fender103718722fender
fer66646122f__er
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fiar76427332fi_ar
fibber134811932fibber
fibers114717522fibers
fibre104812842fibre
fice95737112fice_
fices106031162fices
fie67152442fi_e_
fief107331362fi_ef
fiend95312982fiend
fiery114714792fi_ery
fife106027702fife_
fifed125115972fifed
fifers125414922fifers
fifes114822392fifes
filar84819292filar
file75446642file_
filed95331902filed
filers94623722filers
files85441272files
filet85540162filet
filler94623622filler
filmer114112402filmer
filter94517632filter
fin66458032fin__
final83922032final
finca104714502finca
finch135416972finch
find87532602fin_d
finders113717872finders
finds95424822finds
finely123011562finely
finest94321732finest
fingers113418432fingers
finis86824262finis
fink117532122fin_k
finked144214622finked
finks125424222finks
finned104114602finned
finnier10319952finnier
finny114716752finny
fino76034692fin_o
finos86226952finos
fins75849092fin_s
fir66744892fi__r
fire76245592fire_
fired94829742fired
firers94922682firers
fires85740752fires
firmer114712442firmer
fisher124917142fisher
fitter94120032fitter
five107629742five_
fivers124420922fivers
fives116027362fives
fixed165416952fixed
fixers165112982fixers
fixes154723592fixes
fizzer17369382fizzer
fleer86020772fleer
flier86023402flier
flinder11319872flinder
flinger113710512flinger
flyer114916252flyer
foined105915012foined
fonder104120062fonder
foyer116416552foyer
freer86021242freer
frier85225842frier
frizer184011282frizer
fryer115913432fryer
fumer105918232fumer
funder104016082funder
funker133915762funker
funner93414102funner
gainer74117492gainer
giber85417702giber
ginger84920032ginger
ginner73915822ginner
giver94921202giver
goner66025162goner
hider95024082hider
hiker125119392hiker
hinder104120062hinder
hinger104723332hinger
hinter94021302hinter
hirer85423122hirer
honer85332092honer
inert53234372_inert
infer84215032_infer
inker94421092_inker
inner54920632inner
inter55028492_inter
jiber145115702jiber
jinker174013542jinker
jiver155119052jiver
joiner134114132joiner
kier86526812ki_er
kinder113716842kinder
kine85643432kine_
kines95039132kines
kiter95523212kiter
liber74723622liber
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
limner84112872limner
line46965572line_
linear65113342linear
lined64934642lined
linen55728722linen
liners65428852liners
lines57054572lines
liney87029632liney
linger75226002linger
linier64423792linier
linker104321472linker
linter64625342linter
liter54736342liter
liver85132962liver
loner55431042loner
miler75733062miler
mimer94825762mimer
mincer104017362mincer
minder94822502minder
mine67256172mine_
mined85333352mined
miners84126632miners
mines75651952mines
minor74920062minor
minter84425102minter
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
nine45842172nine_
nines55937342nines
niter55028972niter
oiler54628282oiler
owner84613312owner
pier66035292pi_er
piker115622842piker
pincer104019172pincer
pinder94523452pinder
pine67755712pine_
pined85935322pined
pinery115214292pinery
pines76048862pines
piney105727502piney
pinger94324092pinger
pinier84024692pinier
pinker125322442pinker
pinner84521502pinner
piper96523192piper
refiner105316912refiner
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
ringer74526062ringer
rinser64317212rinser
riper74328402riper
riser55431052riser
river85731692river
ruiner64013642ruiner
saner54334322saner
seiner64622482seiner
shiner93820872shiner
signer74015632signer
siker95326032siker
sine46560622sine_
sines55954822sines
sinew84718922sinew
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinter63625922sinter
siver85728612siver
sizer145521812sizer
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinder73821802tinder
tine45855132tine_
tinea54923162tinea
tined65434532tined
tines54848422tines
tinier63622232tinier
tinker103619922tinker
tinner64119962tinner
tinter63923642tinter
titer55430612titer
toner55336242toner
tuner56022682tuner
twiner94012592twiner
vainer93714572vainer
veiner94514752veiner
vier75428152vi_er
viler86324162viler
vine75643682vine_
vined95626152vined
vinery124912602vinery
vines85137642vines
vinier93716742vinier
viper105017302viper
weiner94214132weiner
whiner124516632whiner
wider94826352wider
wiener94513542wiener
wincer115018192wincer
winder104025262winder
wine74953422wine_
wined94434182wined
winery125014282winery
wines85546862wines
winey115325432winey
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winter94222802winter
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
zine137036152zine_
zineb165614142zineb
zines145232652zines
zinger163816702zinger
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.313570897.8
2DLD Change Limit538003041.48336277.8
3Display Results3043040.0933268.8
 (SQL Overall)1786913041.88994595.6
 
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.