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

504 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
twerps1134515(None) 
twerp10398411twerp_
twirps11415011twirps
ewers86018822ewer_s
perps95521482_perps
sweeps114110512sweeps
tarps76527112t_arps
tawers94118602tawer_s
temps95417132t_emps
terms75523472t_erms
terns55226872t_erns
theres96525472theres
therms115914872therms
thesps11448262thesps
thorps113610892thorps
tiers55526522tier_s
towers94423672tower_s
turps74918732t_urps
tweaks1335962tweaks
tweeds10498432tweeds
tweens9489842tweens
tweets94210102tweets
twiers95410162twier_s
twirls9478122twirls
twirp10468942twirp_
twyers12497412twyer_s
tyers86220052tyer_s
warps107126422_warps
weeps104120562_weeps
agers65027853ager_s
alerts64418223alerts
apers76629133aper_s
avers85127313aver_s
averts95715243averts
awards107113453awards
awes76037553awe__s
beeps95320973_beeps
beers75628393beer_s
bergs84718043_bergs
berks115423123_berks
berms95323663_berms
beweeps1494563beweeps
bewraps14135403bewraps
biers76225223bier_s
bleeps10499103bleeps
bowers115523703bower_s
burps94220173_burps
carps96932253_carps
ceps86125953_ce_ps
ceres75540013_ceres
ceros74726073_ceros
cheaps134613683cheaps
cheeps135312913cheeps
cherts115617233cherts
chirps135414003chirps
clerks12458843clerks
corps95927043_corps
cowers114625533cower_s
creeps104213623creeps
deeps84921773_deeps
deers64930523deer_s
derms85022893_derms
doers65225713doer_s
dorps85419223_dorps
dowers104523293dower_s
dwarfs13436273dwarfs
dweebs1233653dweebs
dwells10417713dwells
dyers96617133dyer_s
egers65120373eger_s
eras45441503__eras
ergs55523813__ergs
erns45428233__erns
eros45238453__eros
errs45622533__errs
ers36046283__er_s
ethers94518413ether_s
etwees9348793etwe_es
everts94514893everts
ewer77523983ewer__
ewes76328703ewe__s
exerts133712293exerts
eyers86521333eyer_s
feres86038183_feres
ferns85220083_ferns
freres94716173freres
germs85118873_germs
goers65520253goer_s
gorps85316993_gorps
haeres94017033haeres
harps105926873_harps
heaps105223223_heaps
helps105219343_helps
hemps126917333_hemps
herbs105520503_herbs
herds96424683_herds
heres86245903_heres
herls85226433_herls
herms105626433_herms
herns84825583_herns
heros84930863_heros
herpes115517323_herpes
hers75844873_her_s
hewers123715273hewer_s
hoers85724923hoer_s
inerts64517023inerts
jeeps144715373_jeeps
jeers124818133jeer_s
jerks166514893_jerks
keeps116020283_keeps
kelps115116423_kelps
kemps135012523_kemps
keps106027303_ke_ps
kerbs115013673_kerbs
kerfs125413573_kerfs
kerns94719563_kerns
kiers95320093kier_s
kreeps12427413kreeps
leaps75522933_leaps
leers54828983leer_s
liers55130403lier_s
lowers94624923lower_s
lweis8458693lwe_is
mercs96020453_mercs
meres75143573_meres
merks114722403_merks
merls77423903_merls
mowers113219403mower_s
neaps75618323_neaps
neeps75617883_neeps
nerds65719253_nerds
nerts55924983_nerts
omers76923193omer_s
operas8312453operas
others93918003other_s
otters64021513otter_s
outweeps1344013outweeps
overs85224793over_s
owes75137103owe__s
owners94210703owner_s
oyers87620883oyer_s
pawers114818783pawer_s
peeps95822363_peeps
peers75130273peer_s
peps85134513_pe_ps
peres76246643_peres
peris75537073_peris
perks115325803_perks
perms95524513_perms
perp89029893_perp_
pervs105117373_pervs
piers75926333pier_s
powers113822323power_s
preops104911943preops
preps96220693pre_ps
querns15307943querns
qwerty2133583qwerty
qwertys224973qwertys
reaps75626193_reaps
repps95114343_repps
reps65937953_re_ps
rewraps12136563rewraps
rowers94924573rower_s
ruers515019413ruer_s
sawers94620163sawer_s
scarps104718603scarps
seeps74828753_seeps
seers55136383seer_s
seres55448893_seres
serfs84922013_serfs
sers45746653_ser_s
sewers94719723sewer_s
sharps115516083sharps
sherds105614723sherds
sherpa1138093sherpa
sherpas1238093sherpas
skelps12407923skelps
skeps115614253ske_ps
sleeps83913323sleeps
slurps84410003slurps
smerks12449713smerks
sneaps84510863sneaps
sowers94923443sower_s
sperms102512603sperms
steeps85215193steeps
steers63820983steer_s
steps76619883ste_ps
steres63929533steres
sterns64616763sterns
stirps85011823stirps
streps86218063stre_ps
suers55128483suer_s
swamps135910263swamps
swaps104819203sw_aps
swards105415133swards
swarfs125612063swarfs
swarms116112173swarms
swears94114073swears
sweats94814613sweats
swedes102711893swedes
sweep104715723sweep_
sweepy14447453sweepy
sweets94214433sweets
swells93913983swells
swept105720603swe_pt
swerve1256293swerve
swerves1377533swerves
swirls94010133swirls
swoops114910923swoops
swops105913973sw_ops
swords104510803swords
tabers84621573taber_s
taels56822073tae_ls
tahrs85412333tahr_s
takers103923743taker_s
takeups1333403takeups
talers64628143taler_s
tamers84224033tamer_s
tamps95524083t_amps
tapers84025813taper_s
taps66050673t__aps
tares57456563t_ares
tarns56433953t_arns
taros55640823t_aros
tarp66936413t_arp_
tarres64723043tarres
tars46763953t_ar_s
tarts57242023t_arts
taters64932203tater_s
taverns10317803taverns
tawer85223443tawer__
taxers134015283taxer_s
teaks94222903t_eaks
teals56234133t_eals
teams75726513t_eams
tears55436463t_ears
teas45851493t_e_as
teats55636813t_eats
techs106915833t_echs
teds54932573t_e_ds
teels55726373t_eels
teems76019783t_eems
teens56227483t_eens
tees45353583t_e_es
teffs115111733t_effs
teggs74710743t_eggs
tegs56031493t_e_gs
teles54536003t_eles
tells55828943t_ells
telos55424523t_elos
tels46841693t_e_ls
temp85323333t_emp_
tempi94912203t_empi
tempo95214973t_empo
tempos103812293t_empos
tempt95124843t_empt
tempts10439453t_empts
tends65425583t_ends
tens45647413t_e_ns
tents56434213t_ents
tepa66021683t_e_pa
tepas76521683t_epas
terai53525483t_erai
terais64023513t_erais
teraph11319093t_eraph
terce75721843t_erce
terces83921413t_erces
terga63315643t_erga
term66233153t_er_m
tern46134803t_er_n
terne56426153t_erne
ternes65422903t_ernes
terra54419663t_erra
terras63516973terras
terry84721873t_erry
terse55026823t_erse
tests56530193t_ests
teths85418513t_eths
tetras63017623tetras
tetris62816293tetris
tets45847463t_e_ts
tews76431643t_e_ws
texas126514933t_exas
texts125515043t_exts
tharms115712243tharms
thawers13428483thawer_s
thebes115914493thebes
thefts12387923thefts
thegns10547433thegns
theins95015423theins
theirs94610353theirs
themes115319253themes
thens85921833the_ns
therapy1536613therapy
there87527393ther_e
therm106018023ther_m
therme115814993therme
thermes126214613thermes
thermos124610753thermos
theses96517973theses
thesis94913733thesis
thesp105410313thesp_
thetas93011573thetas
thews117416193the_ws
thirds10438603thirds
thirls95012063thirls
thorns95314103thorns
thorp104414263thorp_
thorpe113610093thorpe
thorpes125010353thorpes
threaps12488643threaps
threeps12687043threeps
threes97117323threes
thrips11299013thrips
thumps13449353thumps
thurls9418713thurls
thwarts1345023thwarts
tiaras6314553tiaras
tiderips1145383tiderips
tier44936143tier__
tierce8339843tierce
tierces93710453tierces
tiered73613973tiered
ties45248313tie__s
tigers75616513tiger_s
tilers63523503tiler_s
timers84420993timer_s
tips66436763t__ips
tires55437493t_ires
tirls54519803t_irls
tiros54524893t_iros
titers64526413titer_s
titres64718933titres
tmeses85712243tmeses
tmesis8529793tmesis
toeas55726423toe_as
toecaps1135553toecaps
toes46956443toe__s
tokers104818893toker_s
toners64128003toner_s
topers85025323toper_s
tops66248123t__ops
toras55540373t_oras
torcs75123763t_orcs
toreros7311343toreros
tores55352673t_ores
toros54336193t_oros
torrs53923563t_orrs
tors46157383t_or_s
torts56138123t_orts
torus54329763t_orus
toters65026363toter_s
tours55325893tour_s
towards1138783towards
towels94314643towe_ls
tower85729203tower__
towered112911403towered
towery124012093tower_y
toyers95516333toyer_s
tramps105114453tramps
traps75727483t_raps
treads74817923treads
treats64821693treats
treens65317873treens
trees55835763tre_es
treks96016853tre_ks
trends75513543trends
tres46542903t__res
tress55423163tre_ss
trets55928023tre_ts
trews86118893tre_ws
treys85018213tre_ys
triers64321523trier_s
trips74923363t_rips
tromps104911703tromps
troops85712783troops
trumps104611883trumps
tsars56717113tsar_s
tsores65113663tsores
tsoris63411193tsoris
tsuris62710203tsuris
tubers85017033tuber_s
tulips8137253tulips
tumps95420793t_umps
tuners64417343tuner_s
tuneups933333tuneups
tups65628763t__ups
turds65021693t_urds
turfs84620443t_urfs
turks95320823t_urks
turns55623243t_urns
tuyeres10417793tuyeres
tuyers94612563tuyer_s
twaes86513663tw_aes
twains95811183twains
twangs10358093twangs
twas76824083tw__as
twats86616603tw_ats
tweak1257753twe_ak
tweaky1634023tweaky
twee76827083twe__e
tweed94915093twe_ed
tweedy13455933tweedy
tween84413743twe_en
tweeny12477003tweeny
tweet84823983twe_et
tweeze18265473tweeze
tweezes19345703tweezes
twelve1234163twelve
twelves1334303twelves
twenty1236223twenty
twier84713293twier__
twigs96911173tw_igs
twills9489793twills
twiners10459633twiner_s
twines94717273twines
twins85118983tw_ins
twirl85011943twir_l
twirly12427083twirly
twists9549753twists
twits86015793tw_its
twofers1364053twofer_s
twos76718023tw__os
twyer11558523twyer__
tyees86019453tye_es
tyer75323393tyer__
tyes76433373tye__s
typps12549303t_ypps
tyres84725233t_yres
tyros85118593t_yros
tzars144914273tzar_s
tzuris15286913tzuris
urps66920483__urps
users55817573user_s
usurps8105073usurps
uterus639203uterus
utters63817123utter_s
veeps104715723_veeps
veers84521363veer_s
verbs104614393_verbs
verts85724733_verts
viers85621953vier_s
vowers124317183vower_s
waps96642083_w_aps
wards97734403_wards
wares88250583_wares
warks127932403_warks
warms107726853_warms
warns87231003_warns
warp95635003_warp_
wars78659803_war_s
warts814840403_warts
wasps106714693_wasps
weals85428743_weals
weans85326743_weans
wears86030303_wears
webs96622123_we_bs
weds86628933_we_ds
weeds95222213_weeds
weeks125017863_weeks
weens85224053_weens
weep95131653_weep_
weepy134212593_weepy
wees76249123_we_es
weets85427723_weets
wefts116715493_wefts
weirds10478053_weirds
weirs84316493_weirs
wekas123911793_wekas
welds94719163_welds
wells85426193_wells
welts85225193_welts
wends95822813_wends
wens76337933_we_ns
wept95635053_we_pt
were76238333_wer_e
wert79749823_wer_t
wests85727003_wests
wets75940293_we_ts
whaps135115163_whaps
wheeps14439953wheeps
whelps14437843whelps
wheres125917433wheres
whips134917083_whips
whops135013933_whops
whups134210003_whups
wimps125213803_wimps
wires86034913_wires
wisps105214183_wisps
woops104917523_woops
wops96634153_w_ops
words95425073_words
works125621903_works
worms105320763_worms
worts88631183_worts
wraps105617153_wraps
wrens85016243_wrens
xerus12313333_xerus
yelps105712993_yelps
yeps95924403_ye_ps
yerks125416563_yerks
zeps156019343_ze_ps
zerks185113823_zerks
zeros144918113_zeros

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.373479064.3
2DLD Change Limit1127165044.76623650.0
3Display Results5045040.1563230.8
 (SQL Overall)1786915045.29533747.1
 
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.