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

377 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
tawpie1133914(None) 
tawie84819811taw_ie
tawpies12309871tawpies
bawtie113812142bawtie
cowpie133511512cowpie
dawtie103011092dawtie
gawsie1038462gawsie
hawkie163810092hawkie
kewpie15465412kewpie
magpie1139092magpie
nappie104112262nappie
talkie103914442talkie
tammie104212692tammie
tape64538142ta_p_e
tapir75917062ta_pir
tapis75028862ta_pis
tassie66017022tassie
tattie64817512tattie
taupe7314162taup_e
tawnier10318462tawnier
tawnies102812502tawnies
tawse85616502taw_se
towie85821872tow_ie
townie93312302townie
aerie54634603_aerie
aggie73415013_aggie
alkie95520033_alkie
alpine84417373_alpine
amie66339853_a_mie
ample94720303_ample
ape57251183_a_p_e
apple94517673_apple
apse67725383_a_pse
aspic95114733_aspic
aspire8612123_aspire
aspis74618143_aspis
atopic103514143atopic
atopies92816433atopies
atwain937813atwain
atypic13337653atypic
await85524493_await
awake125014783_awake
aware86420023_aware
awe67746623_aw__e
awee76336643_aw_ee
awhile1257793_awhile
awoke124912003_awoke
baddie104114033baddie
baggie102912193baggie
bagpipe1453113bagpipe
bailie83818363bailie
barbie105018353barbie
barmie103816393barmie
bawbee132714233bawbee
bawdier13378203bawdier
bawdies134613393bawdies
bawties124214313bawties
brawlie12198153brawlie
buppie12288733buppie
cabbie122913353cabbie
caddie104316453caddie
cammie124615293cammie
campi116217783campi_
campier133313273campier
cannie83819363cannie
cape87242783ca_p_e
capiz18514563ca_piz
carnie84421093carnie
carpi94319393carpi_
cattie85221023cattie
cavie104621593ca_vie
chappie16298653chappie
cowpies143314283cowpies
cowrie113814283cowrie
crappie13298983crappie
dapple1138853dapple
darkie113714013darkie
dassie74615573dassie
dautie72914703dautie
dawdle11399503dawdle
dawties113312703dawties
dowie94721143dow_ie
etape74413703eta_p_e
faerie93514683faerie
falsie93513853falsie
farcie114816473farcie
fawnier13296363fawnier
gape75134513ga_p_e
gappier12369843gappier
garpike1435093garpike
gawkier15326523gawkier
gawkies15429123gawkies
gawp107618633gawp__
gawped13509073gawped
gawper12499693gawper
gawping14418463gawping
gawps115911013gawp_s
hackie154615623hackie
hankie133915713hankie
happier143312033happier
harpies123818313harpies
harpin113614383harpin
hatpin112610613hatpin
hawkies173311243hawkies
hawse116015123haw_se
hempie132410563hempie
hippie132811243hippie
howdie13349733howdie
jape134923423ja_p_e
jawlike21116003jawlike
jawline17137063jawline
kelpie12308613kelpie
kewpies16246923kewpies
koppie14277883koppie
laddie83713173laddie
lambie103213673lambie
lapin75222923la_pin
lapis76223153la_pis
lapse74917683la_pse
lassie64917743lassie
lawine93316463lawine
lawlike14137073lawlike
magpies12310363magpies
mamie95826003ma_mie
mammie94313783mammie
maple95521143ma_ple
mashie11315933mashie
mavie104722563ma_vie
nannie63713223nannie
nape65230803na_p_e
nappe96114993na_ppe
nappier114411173nappier
nappies114613393nappies
newbie11135413newbie
newie81813483new_ie
newsie9138213newsie
palpi95414553palpi_
panpipe1034833panpipe
pantie84326473pantie
pappi84810893pappi_
pappier103511593pappier
pappies103214823pappies
pardie96021443pardie
pastie85525523pastie
pattie84020963pattie
pawkier16236613pawkier
pawnee113115403pawnee
pawpaw1653503pawpaw
pie55457403___pie
potpie103412433potpie
ramie75027823ra_mie
rampike1536603rampike
ranpike1335933ranpike
rape65041633ra_p_e
raphe104916423ra_phe
rapid86422033ra_pid
rapier84019993ra_pier
rapine85023083ra_pine
rappee103618673rappee
raspier93110643raspier
rawhide14134973rawhide
rawin85521473raw_in
salpae84614273salpae
salpid9510883salpid
saltie63422433saltie
sample104215013sample
sapid84720933sa_pid
sappier113613113sappier
sawlike14138443sawlike
sharpie1238393sharpie
staggie9138463staggie
staple84415823sta_ple
swipe105217083_swipe
tabbied12297793tabbied
tabbies112913503tabbies
tabbis102910863tabbis
tabid84418263ta_bid
table75429603ta_ble
tace65342513ta__ce
tache106222373ta_che
tacit76333673ta_cit
tackier133712523tackier
tackle123815733tackle
tacrine9311293tacrine
tactic10612753tactic
tactile9310613tactile
tadpole1036143tadpole
tae38267053ta___e
taenia6313193taenia
taeniae739083taeniae
taffia12286903taffia
taffies133012693taffies
tafia84215493ta_fia
taglike12278913taglike
tagline82412453tagline
tahsil936343tahsil
tail45443653ta__il
taille63116923taille
tailpipe1253003tailpipe
tain45548073ta__in
taipan82410663taipan
takahe1335793takahe
take84739263ta__ke
takin94921303ta_kin
tale46154163ta__le
tali46837163ta_li_
taliped1078203taliped
talipes9611603talipes
talkier114011843talkier
talkies113415733talkies
tallied83314753tallied
tallier72817213tallier
tallies73624603tallies
tallis63319963tallis
tallit63422733tallit
tamale83717403tamale
tame66343663ta__me
tamein8313093tamein
tamis76728733ta_mis
tammies113814683tammies
tamp86133003tamp__
tampan102512323tampan
tamped114317043tamped
tamper104618513tamper
tamping122815813tamping
tampion11298663tampion
tampon102911233tampon
tamps95524083tamp_s
tangier83013903tangier
tangle74019953tangle
tannic82811473tannic
tannin62613923tannin
tansies74521243tansies
tap57663873ta_p__
tapa65129143ta_p_a
tapas74627713ta_pas
taped85327423ta_ped
taper74829773ta_per
tapes75838603ta_pes
taping94222393ta_ping
tapirs84113173ta_pirs
tapises92914013ta_pises
tapped113820053tapped
tapper104419613tapper
tappet103820113tappet
tapping123317133tapping
taps66050673ta_p_s
tardier859719993tardier
tardies84225863tardies
tardive1136893tardive
tare45957623ta__re
targe65227093ta_rge
tarp66936413tarp__
tarpan82814293tarpan
tarpon82812803tarpon
tarps76527113tarp_s
tarre55825633ta_rre
tarried83914133tarried
tarrier74323173tarrier
tarries73324263tarries
tarsi55222173tarsi_
tarsia65514273tarsia
tarsier74119253tarsier
tartier74123263tartier
tasse54821843ta_sse
tassies74918933tassies
taste55127233ta_ste
tastier711817093tastier
tate44748603ta__te
tattier74216243tattier
tatties74120343tatties
tattle64115653tattle
taupes8212673taupes
taurine7311363taurine
taw610155453taw___
tawdrier12133433tawdrier
tawdries12136083tawdries
tawdry13395253tawdry
tawed95926193taw_ed
tawer85223443taw_er
tawers94118603tawers
tawing104521553tawing
tawney12338233tawney
tawniest11279343tawniest
tawnily1335443tawnily
tawny114713653taw_ny
taws75641593taw__s
tawsed10499743tawsed
tawses94913193tawses
tawsing1138673tawsing
taxeme1536253taxeme
taxi117124763ta_xi_
taxied14509373ta_xied
taxies135817333ta_xies
taxis126821973ta_xis
taxite13511303taxite
taxpaid1743093taxpaid
taxwise1734253taxwise
tazze1339573ta_zze
teaware1048143teaware
techie11511723techie
teepee8314363teepee
tekkie934203tekkie
tempi94912203tempi_
temple102811333temple
tenpin8310583tenpin
tentie62521183tentie
tepee74724213t_epee
tepid8314313t_epid
tie36557533t___ie
tiepin839343tiepin
tipi69924433t_ipi_
tipis76019923t_ipis
tippier113210543tippier
tipple103411913tipple
tittie63213153tittie
toonie63617993toonie
tope65946383t_op_e
topee76029953t_opee
tophe106718973t_ophe
topi67830393t_opi_
topic95721503t_opic
topis76025833t_opis
topple104411323topple
torpid9310913torpid
toupee8316133toupee
towage1039833towage
towhee122613883towhee
towies93521193tow_ies
towline102911543towline
townee92815213townee
townies103113623townies
traipse935873traipse
trampier12318243trampier
trample11299703trample
trepid9310083trepid
tripe75425383trip_e
triple84215923triple
trope75725803trop_e
tropic103014193tropic
tropin83316753tropin
tropine93116653tropine
tupik1149003t_upik
tushie939723tushie
twae74719573t_w_ae
twain86313623t_wain
twee76827083t_w_ee
twice104711123t_wice
twier84713293t_w_ier
twig87615773t_w_ig
twin76023083t_w_in
twine85822363t_wine
twit76329063t_w_it
type96223743t_yp_e
typic124511963t_ypic
typier1137333t_ypier
vampier14308233vampier
vampire14296673vampire
vapid115614283va_pid
vawntie1343943vawntie
waddie114013323waddie
waffie15338563waffie
wallie93216803wallie
waspier12259053waspier
weepie11258793weepie
wipe94830283__wipe
yabbie13308663yabbie
yawp125215583yawp__
yawped15528103yawped
yawper14437953yawper
yawping16357333yawping
yawps13628793yawp_s
yippie13277843yippie
yowie114616453yow_ie
yuppie13297133yuppie
zappier20458373zappier
zowie174313843zow_ie

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 Limit1127163775.44020719.9
3Display Results3773770.1233065.0
 (SQL Overall)1786913775.93630102.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.