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 “knifer” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

509 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
knifer1359856(None) 
knife1210010131knife_
knifed14528121knifed
knifers14537081knifers
knifes136210211knifes
conifer123212642conifer
fifer115519972_fifer
heifer1238202heifer
infer84215032in_fer
kaiser103610372kaiser
kier86526812k_i_er
kinder113716842kinder
kiter95523212k_iter
knitter11348132knitter
knives13458552knives
knower1337082knower
lifer85822152_lifer
nicer74618292_nicer
niffer12378442_niffer
niter55028972_niter
rifer84721982_rifer
snider74413912snider
sniffer13318902sniffer
snifter10349622snifter
sniper84413642sniper
unifier102211862unifier
uniter64619142uniter
abider95314463abider
aider65431133_aider
aimer75926823_aimer
airer54927893_airer
aiver85725163_aiver
aliner65621983aliner
anger66225873an_ger
angler74017863angler
anile54634463anile_
anime75423203anime_
animes84719593animes
anise55129703anise_
anises64826693anises
answer936893answer
anther93715063anther
antifur1047493antifur
antler64615553antler
aquifer1934883aquifer
arider74717743arider
bailer85425253bailer
baiter84422553baiter
bider85728373_bider
bier65531833_bi_er
biker116022563_biker
binder94422873binder
biner75930693_biner
binger94923453binger
biter75030033_biter
boiler84319273boiler
bonier84321993boni_er
briber104714053briber
briefer1235563briefer
brier74527403bri_er
briner84519043briner
buffer144512683buffer
ceiler84013963ceiler
chafer144714573chafer
chicer134513603chicer
chider125116053chider
chiefer1536863chiefer
chimer135517203chimer
cider84723313_cider
cinder94119123cinder
citer74827333_citer
coffer144112863coffer
coifed124113063coifed
coiler84421593coiler
coiner84323783coiner
coinfer12419393coinfer
confer114018683confer
conifers133611703conifers
crier74724463cri_er
daiker115113033daiker
deafer104114813deafer
defer94619753_defer
deffer134411303deffer
defier105118653defier
deicer94114413deicer
deifier113013123deifier
denier74420693deni_er
dicer85426423_dicer
differ133910843differ
diker105524553_diker
dimer85625603_dimer
diner65632903_diner
dinger85323673dinger
dinner74217163dinner
direr64927073_direr
diver94827803_diver
doffer133911353doffer
drier64423963dri_er
drifter11348703drifter
driver104714493driver
duffer134711663duffer
duiker114110593duiker
edifier11309263edifier
eider64624743_eider
ender64325863en_der
enter54726383en_ter
enticer91510423enticer
envier939673envier
epimer10109153epimer
eviler94811893eviler
exiler134712183exiler
fainer94717243fainer
fairer95212063fairer
fer66646123___fer
fiber104921133_fiber
fife106027703_fife_
fifed125115973_fifed
fifers125414923_fifers
fifes114822393_fifes
filer85433003_filer
finder104020233finder
finer85431563_finer
finger104920333finger
firer811229253_firer
fiver116024943_fiver
fixer154717833_fixer
flier86023403fli_er
frier85225843fri_er
frizer184011283frizer
gaffer134310133gaffer
gainer74117493gainer
gaiter73819503gaiter
giber85417703_giber
ginger84920033ginger
ginner73915823ginner
giver94921203_giver
glider84614263glider
gnawer10386953gnawer
gofer94814283_gofer
goffer13409513goffer
goiter74116203goiter
golfer104411183golfer
grifter113810493grifter
griper94114613griper
guider84313523guider
hailer94720343hailer
heifers1337933heifers
hider95024083_hider
hiker125119393_hiker
hinder104120063hinder
hinger104723333hinger
hinter94021303hinter
hirer85423123_hirer
hoofer124014953hoofer
icier74313753ici_er
iffier1236763iffier
igniter8147673igniter
inaner62213543inaner
incher114114033incher
inciter93113773inciter
inditer83514233inditer
infers93615443in_fers
inker94421093in_ker
inkier104013783inkier
inlier63615363inlier
inner54920633in_ner
insider849733insider
inter55028493in_ter
inviter104112313inviter
ionizer162310123ionizer
jailer134316683jailer
jiber145115703_jiber
jinker174013543jinker
jiver155119053_jiver
joiner134114133joiner
juicer1536283juicer
juniper1634023juniper
kaffir16345303kaffir
kafir12488903k_afir
kaif116933933kaif__
kaifs125715643kaif_s
kaisers11369273kaisers
kasher134915033kasher
keener104012843keener
keeper123811923keeper
kefir12457913k_efir
kegger12388083kegger
kegler11398243kegler
keir86217873kei__r
keister113011573keister
kelter103214383kelter
kerfed14358233kerfed
kibe106523453k_ibe_
kibei114311533k_ibei
kibes115521113k_ibes
kicker114116183kicker
kidder123811103kidder
kief117128413k_i_ef
kiefs126112203k_iefs
kiers95320093k_i_ers
kif105941193k_if__
kifs116023513k_if_s
kike76524793k_ike_
kikes85122553k_ikes
killer104917953killer
kilter103714343kilter
kindler12309983kindler
kine85643433k_ine_
kines95039133k_ines
kinged124215293kinged
kinked104014753kinked
kinkier10319433kinkier
kipper143414213kipper
kir76535683k_i__r
kisser104212453kisser
kite85338243k_ite_
kited105120093k_ited
kiters105218593k_iters
kites95432543k_ites
klister113410643klister
knacker12307913knacker
knapper15387153knapper
knar85818723kn__ar
knaur9508253kn_aur
knave12389463knave_
knavery1733123knavery
knaves13439523knaves
knawe12397883knawe_
knawel13415413knawel
knawes13328393knawes
kneader1275893kneader
knee85323603kn__ee
kneed104612053kn_eed
kneel95012033kn_eel
kneeler11277573kneeler
knees95114873kn_ees
knew115912123kn__ew
knickers13306723knickers
knifing1536483knifing
knight1438173knight
knish1238603kni_sh
knishes1438263knishes
knit85728143kni__t
knits93914743kni_ts
knitted12337423knitted
knitters12336623knitters
knitwear1591463knitwear
knocker12296393knocker
knoller11285913knoller
knotter11317643knotter
knowers1436353knowers
knur85311973kn__ur
koine9516483koine_
koines10415733koines
kosher134412973kosher
krater104014313krater
krimmer15376873krimmer
krises105016083krises
kroner104612573kroner
liber74723623_liber
liefer9529573liefer
lier45942463_li_er
life75433733_life_
lifers95617843_lifers
lifter93814813_lifter
liger65024473_liger
liker95627063_liker
liner55938923_liner
linger75226003linger
linier64423793linier
linker104321473linker
linter64625343linter
liter54736343_liter
liver85132963_liver
loafer93610943loafer
loiter64619173loiter
lucifer1234603lucifer
lunier64617603luni_er
mailer84724183mailer
maimer104514593maimer
miler75733063_miler
mimer94825763_mimer
mincer104017363mincer
minder94822503minder
miner76933543_miner
miniver1238393miniver
minter84425103minter
miser75430403_miser
miter75734793_miter
mixer145017643_mixer
moiler84017263moiler
moniker1338673moniker
nailer64119363nailer
naiver94311353naiver
namer75622103_namer
never86218643_never
newer85717463_newer
nice65534713_nice_
nicker123818703_nicker
nide55535793_nide_
nided75920873_nided
nides65229133_nides
niffers13287363_niffers
niftier10328713_niftier
nifty115211633_nifty
nigger89713573_nigger
nigher103612753_nigher
nine45842173_nine_
nines55937343_nines
nipper103715713_nipper
nisei54214353_nisei
nite45943583_nite_
niters64624213_niters
nitery94412173_nitery
nites55736343_nites
nitre57519683_nitre
nixe115722023_nixe_
nixed135714223_nixed
nixes124519623_nixes
noter55025643_noter
nuder66416833_nuder
offer114311383_offer
oiler54628283_oiler
onager739663onager
osier53518013osi_er
panier84425503pani_er
pier66035293_pi_er
piker115622843_piker
pilfer1139163pilfer
pincer104019173pincer
pinder94523453pinder
pinger94324093pinger
pinier84024693pinier
pinker125322443pinker
pinner84521503pinner
piper96523193_piper
plier75221283pli_er
poiser84217243poiser
prefer113813203prefer
pricer103918293pricer
prier75027763pri_er
primer105118683primer
prizer174714883prizer
puffer144610733puffer
punier84519223puni_er
quiver18278743quiver
raider74318743raider
railer64524933railer
raiser66620103raiser
reefer93314363reefer
refer84822143_refer
reifier103414523reifier
reiver95318293reiver
ricer74726613_ricer
rider65231303_rider
rife74632323_rife_
rifler94014263_rifler
rimer75429243_rimer
ringer74526063ringer
rinser64317213rinser
riper74328403_riper
riser55431053_riser
river85731693_river
rolfer94412273rolfer
roofer94415283roofer
rotifer1036993rotifer
ruiner64013643ruiner
safer84721813_safer
sailer63526103sailer
seiner64622483seiner
seiser65318343seiser
seizer154114573seizer
shier85428943shi_er
shifter132911083shifter
shiner93820873shiner
shiver124517373shiver
sifter94516233_sifter
siker95326033_siker
singer74227313singer
sinker103620903sinker
sinner64320603sinner
sinter63625923sinter
siver85728613_siver
sizer145521813_sizer
skier95119593ski_er
skinker10319443skinker
skinner11348093skinner
skiver134612103skiver
slicer84117603slicer
slider73918363slider
slier54827243sli_er
sliver94116593sliver
smiler83916683smiler
smiter83616413smiter
snarer64620843snarer
sneer54919953sn_eer
snicker133012673snicker
snide64318723snide_
sniff113915863snif_f
sniffed14318183sniffed
sniffers14257123sniffers
sniffier14356643sniffier
sniffler14296833sniffler
sniffs12378843sniffs
sniffy15337193sniffy
snifters11318613snifters
snigger9328373snigger
snipe75320573snipe_
sniped94913483sniped
snipers93311773snipers
snipes83917393snipes
snipper113911333snipper
snivel9368853snivel
snorer64316763snorer
snuffer13318853snuffer
spicer104719313spicer
spider94516803spider
spier75728033spi_er
spiker124315663spiker
stiffer13319393stiffer
stifler102911473stifler
stiver93915733stiver
suffer124314513suffer
suiter64121813suiter
surfer93515883surfer
swifter13318053swifter
tailer63823733tailer
telfer9379893telfer
tier44936143_ti_er
tiger65718633_tiger
tiler56131023_tiler
timer75626043_timer
tinder73821803tinder
tinier63622233tinier
tinker103619923tinker
tinner64119963tinner
tinter63923643tinter
titer55430613_titer
titfer9409523titfer
toiler63918283toiler
tonier65520713toni_er
trier54328533tri_er
trifler103912153trifler
trimer85717153trimer
triter65120593triter
twier84713293twi_er
twiner94012593twiner
twofer1234353twofer
under64624213un_der
undoer73113043undoer
unfed94614223un_fed
unific1137463unific
unified112413573unified
unifiers11237173unifiers
unifies102714713unifies
uniform1247053uniform
unify113611113unif_y
uniquer1675783uniquer
unisex1358353unisex
unite54828383unite_
united74421543united
uniters73814173uniters
unites65024853unites
unmiter9310393unmiter
unriper9188283unriper
unwiser1037123unwiser
vainer93714573vainer
veiler93814353veiler
veiner94514753veiner
vier75428153_vi_er
viler86324163_viler
vinier93716743vinier
vinifera1443453vinifera
viper105017303_viper
voicer113910543voicer
voider103611553voider
wafer114417643_wafer
waifed134011033waifed
wailer93720323wailer
waiter94321253waiter
waiver124212713waiver
wanier93920683wani_er
weiner94214133weiner
whiffer19105323whiffer
whiner124516633whiner
whiter124316393whiter
wider94826353_wider
wife105228023_wife_
wifed125117743_wifed
wifes114522563_wifes
wifey144913673_wifey
wincer115018193wincer
winder104025263winder
winger104125443winger
winier94522453winier
winker134220293winker
winner94219933winner
winter94222803winter
wiper105421293_wiper
wirer85124953_wirer
wiser85522803_wiser
wiver115924513_wiver
wolfer12429983wolfer
woofer124411363woofer
wrier84521753wri_er
writer94416513writer
zaffer21397153zaffer
zanier154314713zani_er
zinger163816703zinger

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127165094.57624632.0
3Display Results5095090.1732942.2
 (SQL Overall)1786915095.12534866.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.