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

505 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
twofer123435(None) 
twofers1364051twofers
gofer94814282_gofer
hoofer124014952hoofer
roofer94415282roofer
telfer9379902telfer
titfer9409522titfer
toker95924912t_oker
toner55336242t_oner
tooler63818612tooler
tooter64420802tooter
toper75231022t_oper
toter55932132t_oter
tower85729202t_ower
toyer84521552t_oyer
troffer13125862troffer
trover95014662trover
twier84713292tw_ier
twiner94012592twiner
twyer11558522tw_yer
wafer114417652_wafer
wolfer12429982_wolfer
wooer84316692_wooer
woofer124411362woofer
adorer74713453adorer
atoner64817193atoner
avower1236823avower
awoke124912003awoke_
awoken13457163awoken
blower115316573blower
boner75133083_boner
booger94816553booger
booker124719193booker
boomer104618513boomer
boozer174815963boozer
borer75131273_borer
bower107328183_bower
bowler114217313bowler
bowyer14368923bowyer
boxer145016523_boxer
broker124314243broker
buffer144512683buffer
chafer144714573chafer
choker154314373choker
choler113717153choler
cloner84418093cloner
closer84918203closer
clover114617123clover
coder86134223_coder
coffer144112863coffer
comer95832693_comer
confer114018683confer
cooer74831013_cooer
cooker124722453cooker
cooler84824713cooler
cooper104221123cooper
cooter85128613cooter
coper95336093_coper
corer75538873_corer
cover105430773_cover
cower104531773_cower
cowier113616163cowier
coyer105222843_coyer
crofter12299573crofter
crower114117563crower
crozer175112843crozer
deafer104114813deafer
defer94619753_defer
deffer134411303deffer
differ133910843differ
doer57734703_do_er
doffer133911353doffer
doozer163910463doozer
doper86128393_doper
doser66228563_doser
doter65428623_doter
dower95027703_dower
downer104414923downer
dowser104716083dowser
dozer158419273_dozer
droner74717673droner
drover104614593drover
duffer134711663duffer
dwarfer1433683dwarfer
eloper85414153eloper
emoter85415193emoter
evoker13467913evoker
ewer77523983ew__er
feoffer1233023feoffer
fer66646123___fer
fifer115519973_fifer
flower124815503flower
footer94320773footer
fowler123712583fowler
foyer116416553_foyer
gaffer134310133gaffer
gaoler73913573gaoler
glover104513533glover
glower105114933glower
goer56827103_go_er
gofers104711513_gofers
goffer13409513goffer
golfer104411183golfer
gomer85220653_gomer
goner66025163_goner
goober93911743goober
goofed114911383goofed
goofier11339313goofier
gooier73516213gooier
grocer94212143grocer
groper94517253groper
grower104614933grower
heifer1238203heifer
hoer76533983_ho_er
homer105828453_homer
honer85332093_honer
hoofed134614893hoofed
hoofers134513333hoofers
hooker134820173hooker
hooper114518313hooper
hooter94123933hooter
hoover124314433hoover
hoper105829143_hoper
hoser811529763_hoser
hover115524133_hover
howler123514313howler
infer84215033_infer
ironer64216453ironer
isomer8310153isomer
joker165715893_joker
knifer13598563knifer
knower1337083knower
kroner104612573kroner
liefer9529573liefer
lifer85822153_lifer
loafer93610943loafer
lofter94614723_lofter
loner55431043_loner
looker104816953looker
looper83817113looper
looser65219943looser
looter64222323looter
loper75129233_loper
loser54728673_loser
lover85526453_lover
lower85830413_lower
mooner85317833mooner
mooter83921093mooter
moper94925923_moper
mover104220863_mover
mower104523453_mower
niffer12378443niffer
nooser65517823nooser
noter55025643_noter
offer114311383_offer
ofter84116873__ofter
omer67028393__omer
over77227343__over
owner84613313ow_ner
oyer75927653__oyer
pilfer1139163pilfer
plover115312613plover
plower114315063plower
poker115122883_poker
poler74431793_poler
poofter1237163poofter
pooler83819843pooler
poorer82613993poorer
poser75128773_poser
powder123611903powder
power105325953_power
powter114116033powter
prefer113813203prefer
prober104516073prober
proffer15126933proffer
proofer12149103proofer
proper104319953proper
proser84223463proser
prover113819723prover
prower114218123prower
puffer144610733puffer
quoter153510093quoter
reefer93314363reefer
refer84822143_refer
reoffer1335013reoffer
rifer84721983_rifer
rioter64817283rioter
roger64521413_roger
rolfer94412273rolfer
roofed105214743roofed
roofers105013903roofers
roomer84718633roomer
rooser63921883rooser
rooter64926033rooter
roper75431913_roper
rover85527373_rover
rower85430493_rower
safer84721813_safer
scoffer15317023scoffer
scorer84818263scorer
scoter83815483scoter
shoer84722163sho_er
shofar1236313shofar
shover124515993shover
shower124315113shower
sloper84615913sloper
slower94016153slower
smoker124311693smoker
snorer64316763snorer
sober74822413_sober
sofar86115493_sofar
softer94015313_softer
sooner64220463sooner
sorer56236593_sorer
sower85229313_sower
spoofer12368723spoofer
staffer13299093staffer
stiffer13319393stiffer
stoker104417623stoker
stoner65823203stoner
stooker113811733stooker
stooper93813193stooper
stoper84320103stoper
storer64721673storer
stover94115643stover
strafer103912463strafer
stroker114113523stroker
stroyer103510783stroyer
stuffer13349793stuffer
suffer124314513suffer
surfer93515883surfer
swager104013613swager
swayer125210973swayer
sweer84918573sw_eer
swifter13318053swifter
swobber14336543swobber
swooner10358673swooner
swooper12389173swooper
swore84920823swore_
swotter10399473swotter
taber73825823t_aber
taborer9269293taborer
tacker124224503tacker
tagger84017713tagger
tailer63823733tailer
taker95229003t_aker
taler56034873t_aler
talker103916223talker
taller63721963taller
tamer75230103t_amer
tamper104618513tamper
tanker104521133tanker
tanner63722293tanner
taper74829773t_aper
tapper104419613tapper
tarter64023563tarter
taster64930573taster
tater54138613t_ater
tatter64024573tatter
tauter64318023tauter
tawer85223443t_awer
tawnier10318463tawnier
taxer125019363t_axer
tearer64822903tearer
teaser65421523teaser
tedder83312163tedder
teemer85515743teemer
teener64717503teener
teeter65420313teeter
telfers10299083telfers
teller63519833teller
temper103914093temper
tender74121843tender
tenner64117103tenner
tenoner739683tenoner
tenser64919433tenser
tenter64623933tenter
termer85717253termer
terser67317823terser
tester64227153tester
tether93716103tether
tetter64322453tetter
thaler94613103thaler
thawer12489343thawer
thole85620843thole_
tholed105113873tholed
tholes94919783tholes
those85218143those_
thoued10429003thoued
thrower1387003thrower
ticker124321503ticker
tidier73515113tidier
tier44936153t__ier
tiffed13368393tiffed
tiger65718633t_iger
tiler56131023t_iler
tiller64222543tiller
tilter63417693tilter
timber104012683timber
timer75626043t_imer
tinder73821803tinder
tinier63622233tinier
tinker103619923tinker
tinner64119963tinner
tinter63923643tinter
tipper103918413tipper
titer55430613t_iter
titfers10318933titfers
tither94920283tither
titter63421163titter
tocher114014913tocher
toe310166853t_o_e_
toea46732333t_o_ea
toed56137043t_o_ed
toes46956443t_o_es
toff105929903t_of_f
toffee123311013toffee
toffs116016723t_offs
toffy145310283t_offy
toft77441653t_of_t
tofts84919243t_ofts
tofu76921333t_of_u
tofus86415423t_ofus
toiler63918283toiler
toke86738493t_oke_
toked105626493t_oked
token95419313t_oken
tokers104818893t_okers
tokes95234973t_okes
tolar55524113t_olar
tole46052903t_ole_
toled65934923t_oled
toles55147133t_oles
toller63819443toller
tome67543193t_ome_
tomes76037383t_omes
tone46953743t_one_
toned65435343t_oned
toners64128003t_oners
tones56048663t_ones
toney86027413t_oney
tonger74719693tonger
tonier65520713tonier
tonner64819203tonner
tooled74918903tooled
toolers74416503toolers
tooted74620123tooted
tooters73818773tooters
tootler73511123tootler
tope65946383t_ope_
toped85631313t_oped
topee76029953t_opee
topers85025323t_opers
topes76941763t_opes
topper103817603topper
tor39261683t_o__r
tore47359323t_ore_
torero6313203t_orero
tores55352673t_ores
torr45630903t_o_rr
tosser64215663tosser
tote46643673t_ote_
toted64929483t_oted
totem74819373t_otem
toters65026363t_oters
totes55139683t_otes
tother94117143tother
totter65021463totter
tour45530383t_o_ur
tourer64115073tourer
touter63821033touter
towed95134583t_owed
towel84920523t_owel
towers94423673t_owers
towery124012093t_owery
towhee122613883towhee
towie85821873towie_
towies93521193towies
townee92815213townee
toyed96019803t_oyed
toyers95516333t_oyers
tracer84820233tracer
trader75218763trader
trier54328533t_rier
trifler103912153trifler
trimer85717153trimer
triter65120593triter
trocar848773trocar
trode65322853trode_
troffers14125433troffers
troke94821053troke_
troked114114583troked
trokes104019263trokes
troller73913173troller
trone55131863trone_
trones65629283trones
trooper94210363trooper
trope75725803trope_
tropes84824353tropes
trotter73312253trotter
trouper93811433trouper
trouser73812473trouser
trove85221923trove_
trovers103713323trovers
troves94719113troves
trowed104714653trowed
trowel94211463trowel
truer54916643t_ruer
tsores65113663tsores
tubber104313203tubber
tuber75420683t_uber
tucker124316953tucker
tuffet122612083tuffet
tufter9319933tufter
tugger84013103tugger
tuner56022683t_uner
turfed103110963turfed
turfier10249793turfier
turner63914613turner
tusker104212193tusker
tusser64615833tusser
tutoyer1033793tutoyer
tuyer85414293t_uyer
twae74719573tw_ae_
twaes86513663tw_aes
twanger11327443twanger
twee76827083tw__ee
tweed94915093tw_eed
tween84413743tw_een
tweener10306833tweener
tweet84823983tw_eet
tweeter10288533tweeter
tweezer19305763tweezer
twerp10398413tw__erp
twice104711123twice_
twiers95410163tw_iers
twine85822363twine_
twined104413123twined
twiners10459633twiners
twines94717273twines
twinier1037313twinier
twirler10285203twirler
twister10308953twister
twitter10278093twitter
two67925833two___
twofold1442283twofold
twos76718023two__s
twyers12497413tw_yers
tyer75323393t__yer
typier1137333typier
vomer105517383_vomer
voter85121053_voter
vower115220793_vower
wader95325373_wader
wafers124316153_wafers
wafery15398703_wafery
wafter124114613_wafter
wager95925063_wager
waker125526603_waker
waler84229293_waler
water84733323_water
waver115025713_waver
waxer154317493_waxer
weber10313523_weber
weer75535093_w_eer
wider94826363_wider
wife105228033_wife_
wifed125117743_wifed
wifes114522563_wifes
wifey144913673_wifey
wiper105421293_wiper
wirer85124953_wirer
wiser85522803_wiser
wiver115924513_wiver
woe66651243_wo_e_
woes76440663_wo_es
woful1158173_woful
woke115527963_woke_
woken124614973_woken
wolfed13428013_wolfed
wolfers13409633_wolfers
wolver12419713_wolver
women104619253_women
womera11137593_womera
wonder103617813_wonder
wonner95114443_wonner
wooed94419873_wooed
wooers93712443_wooers
woofed134511203woofed
woofers133810583woofers
wooler93615873wooler
wore77144673_wore_
worker134715113_worker
wormer114514913_wormer
worser95117523_worser
wove105624313_wove_
woven115215173_woven
wowed124023773_wowed
wowser125110203_wowser
wrier84521753_wrier
wryer11489303_wryer
yowler123310043yowler
zaffer21397153zaffer
zoner144520343_zoner
zooier153411233zooier

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 Filter1786911127160.686260482.5
2DLD Change Limit1127165058.70312951.4
3Display Results5055050.1732919.1
 (SQL Overall)1786915059.56218687.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.