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

234 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
twelve123416(None) 
twelves1334301twelves
delve96018262_delve
helve115018092_helve
shelve124012762shelve
swerve1256292swerve
telae54323292t_elae
tele45040872t_el_e
twee76827082twe__e
tweeze18265472tweeze
twelvemo164932twelvemo
weave115218532_weave
abele76323253abel_e
anele55628833anel_e
awee76336643awe__e
belie75630383_belie
belive115415303_belive
belle75827833_belle
breve105317053bre_ve
calve105919923_calve
chelae113614603chelae
cleave114212513cleave
deave95022333_deave
dele56843083_del_e
delved114112753_delved
delver104913493_delver
delves104917083_delves
dwell9519853dwel_l
dwelled12337593dwelled
dweller11297273dweller
dwells10417713dwells
dwelt94316523dwel_t
eave75733583__eave
else45923083__else
elver85216243__elver
elves85118743__elves
etwee84115333etwe__e
eve66331163__e_ve
evolve12306503evolve
gelee63626983_gelee
greave104611493greave
halve114818923_halve
heave114521813_heave
helved134313703_helved
helves124316063_helves
inweave1344723inweave
keeve124512133_keeve
leave84723723_leave
lieve86315473lie_ve
melee73729103_melee
nerve86617373_nerve
neve76224833_ne_ve
nieve85613183nie_ve
peeve104915253_peeve
pele65539553_pel_e
pelves114514663_pelves
reave84528023_reave
reeve84121323_reeve
reive85522943_reive
releve95116403_releve
relive95120783_relive
reweave1336773reweave
rewove126420083rewove
salve85022133_salve
selle54428313_selle
selva83014273_selva
selves94119613_selves
serve85425963_serve
sheave124514003sheave
sheeve123412843sheeve
shelved14379933shelved
shelver134211063shelver
shelves134112093shelves
shelvy15377863shelvy
sieve84918843sie_ve
sleave94714153sleave
sleeve93411593sleeve
solve85618943_solve
steelie7310213steelie
steeve93710903steeve
stelae63716483stelae
stele55026843stel_e
svelte9319753svelte
swale85221593swal_e
swede94413203swe_de
swell84815983swel_l
swelled113211693swelled
sweller103012463sweller
swells93913983swells
swelter103711173swelter
swerved1455703swerved
swerver1365733swerver
swerves1377533swerves
sweven1235983swe_ven
swive115316193sw_ive
table75429603tabl_e
tael46030713tael__
taels56822073tael_s
taille63116923taille
tale46154163t_al_e
tease55428713t_ease
tee38366873t_e__e
teel46335803teel__
teels55726373teel_s
teepee8314363teepee
teethe94511313teethe
tel35647903t_el__
tela45532973t_el_a
telco7511873t_elco
teles54536003t_eles
telex125214823t_elex
telfer9379893t_elfer
telia55821143t_elia
telic76019823t_elic
tell44934703t_el_l
teller63519813t_eller
tells55828943t_ells
telly84920823t_elly
telnet6518833t_elnet
teloi54217383t_eloi
telome8311923t_elome
telos55424523t_elos
tels46841693t_el_s
tenge65720443t_enge
tense55225843t_ense
tepee74724213t_epee
terce75721843t_erce
terne56426153t_erne
terse55026823t_erse
thebe107515433the_be
thecae11299653thecae
thee78039063the__e
theine94814923theine
theme105921733the_me
thence112010843thence
there87527393the_re
therme115814993therme
these86519013the_se
thieve1235963thieve
thole85620843thol_e
thrave126010273thrave
thrive125313223thrive
throve128012393throve
tierce8339843tierce
tilde65017343t_ilde
tile45451443t_il_e
title54721073titl_e
toelike11149823toelike
toile54626493toil_e
tole46052903t_ol_e
towel84920523towel__
toweled112410223toweled
towelled1236353towelled
towels94314643towel_s
trave85223033t_rave
treble8311663treble
tree47745813tre__e
trevet94818913tre_vet
trove85221923t_rove
truelove1142973truelove
tsetse664693tsetse
tuille63012643tuille
tule45735873t_ul_e
tulle54019933t_ulle
twae74719573tw__ae
tweak1257753twe_ak
tweaked1534403tweaked
tweaks1335963tweaks
tweaky1634023tweaky
tweed94915093twe_ed
tweedle1134193tweedle
tweeds10498433tweeds
tweedy13455933tweedy
tween84413743twe_en
tweener10306833tweener
tweens9489843tweens
tweeny12477003tweeny
tweet84823983twe_et
tweeted11336583tweeted
tweeter10288533tweeter
tweets94210103tweets
tweezed20274993tweezed
tweezer19305763tweezer
tweezes19345703tweezes
twelfth1641683twelfth
twelvemos175723twelvemos
twenty1236223twenty
twerp10398413twe_rp
twerps11345153twerps
twice104711123tw_ice
twilit949553twilit
twill85612723twil_l
twilled11398033twilled
twills9489793twills
twine85822363tw_ine
twinge104210403twinge
tyee75131423tye__e
tzetze1432733tzetze
unweave1336363unweave
valve114515933_valve
velvet123613753_velvet
verve115417723_verve
waive114214603_waive
wale74546433_wal_e
wave105234733_w_ave
weaved133913483_weaved
weaver123916613_weaver
weaves123616373_weaves
wedge105215663_wedge
wee66760813_we__e
weever123811443_weever
welch134411493_welch
weld84727733_wel_d
welded114013383_welded
welder102914413_welder
welds94719163_welds
well75832043_wel_l
welled103820213_welled
wellie92814913_wellie
wells85426193_wells
welly114620013_welly
welsh113110363_welsh
welt75547863_wel_t
welted103715823_welted
welter93417383_welter
welts85225193_welts
were76238333_we_re
wherve15568113wherve
wile75944373_wil_e
wive105931753_w_ive
wolver12419713_wolver
wolves124510853_wolves
wove105624313_w_ove
wyle105519383_wyl_e

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.390458182.1
2DLD Change Limit1127162344.58024610.5
3Display Results2342340.0633714.3
 (SQL Overall)1786912345.03335503.9
 
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.