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

280 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
posture931325(None) 
pasture9311461pasture
postured1139491postured
posturer1038921posturer
postures10313781postures
costume1157852costume
couture9310622couture
gesture839242gesture
imposture1343662imposture
moisture1046652moisture
pastured1138232pastured
pasturer1037522pasturer
pastures10311962pastures
picture1158612picture
poseur8419402poseur_
poseurs9378302poseurs
postage103214852postage
postburn1243922postburn
poster84129172poster_
postern93615612postern
posters93928012posters
postfire1346272postfire
postie84123962post_ie
postlude1144542postlude
postural1049202postural
posturers1137052posturers
pustule937682pustule
torture738592torture
vesture10310372vesture
aperture1046393aperture
apostate1049853apostate
apostle937853apost_le
assure6610773_assure
astute6310763_astute
austere7312993austere
bistre83815023bist_re
bordure1035783bordure
bosque17257733bosqu_e
capture1138913capture
closure9278483clos_ure
cloture9238453cloture
coenure968153coenure
colure8314163co_lure
conjure16109073conjure
construe1049053construe
contuse9311413contuse
costae85319683cost_ae
costar85518613costar_
costard104113353costard
costars94218013costars
costate94019273costate
coster84331293coster_
costers94128343costers
costive12312843costive
costrel9310373cost_rel
costumed1365033costumed
costumer1275103costumer
costumes1258013costumes
costumey1563523costumey
coutures10311993coutures
culture939393culture
dasyure1153823dasyure
denture8311893denture
disturb1046233disturb
ensure63416003ens_ure
exposure1743673expos_ure
facture12108943facture
feature1039853feature
fissure1036783fissure
fixture1734963fixture
fortune1068303fortune
foster94322223foster_
fostered122210453fostered
fosterer11239523fosterer
fosters104220103fosters
future939563_future
gestured1036993gestured
gesturer935983gesturer
gestures9310013gestures
goitre7349003goit_re
hostage113111233hostage
hostile10312553hostile
hostler103411023hostler
impostume1542853impostume
impostures1443803impostures
insure63416603ins_ure
jointure15134833jointure
jostle13319863jost_le
jostler14288223jostler
lecture9149523lecture
lustre64011683lust_re
mature8313473_mature
mistune9310653mistune
mixture1635413mixture
moistures1147323moistures
mosque17287163mosqu_e
moste75925083most__e
multure939183multure
nature6311263_nature
noctule936083noctule
nocturn944653nocturn
nocturne1043393nocturne
nostrum946953nostrum
nurture736643nurture
obscure1145333obscure
obtuse8147483_obtuse
oospore939013oospore
ordure756813_ordure
oscule838193_oscule
ossature843303ossature
ostler63312193_ostler
outre53922203_out_re
parure8312523p_arure
paste74932953past__e
paster85734373paster_
pastern94415063pastern
pasters94531733pasters
pastie85525523past_ie
pastier94320383pastier
pastime114611973pastime
pastor84817483pastor_
pastored1139973pastored
pastors94119003pastors
pastry114913033past_ry
pasturage1244923pasturage
pastural1038413pastural
pasturers1136393pasturers
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
pester84827593pester_
pestered112814973pestered
pesterer102412713pesterer
pesters93827093pesters
pestier94317403pestier
pestle83215843pest_le
piastre9307893piast_re
pictured1346573pictured
pictures1249343pictures
pismire1135353pismire
piste75824603pist__e
pistole92414313pistole
poetise9314043poetise
poetize18310773poetize
poetry1139383poet_ry
poitrel936193poit_rel
pollute937383pollute
pontine92419053pontine
pore66451263po___re
portage103013643portage
porter84224413porter_
portered112311553portered
porters93722703porters
portiere1038773portiere
posable112212783posable
pose66441733pos___e
poser75128773pos_er_
posers84223973pos_ers
posher115018163posher_
positive1349993positive
posole8314223pos_ole
posse74722273pos__se
possum1057953possu_m
possums1145753possums
post67953363post___
postages112815323postages
postal84317533post_al
postals93716383postals
postbag1245223postbag
postbase1246443postbase
postbox1885493postbox
postboy1476673postboy
postcard1346523postcard
postcode1346323postcode
postdate1139653postdate
postdive1445763postdive
postdoc1245263postdoc
postdrug1243093postdrug
posted93722493post_ed
posteen93512623posteen
posterns102713723posterns
postface1566123postface
postfix1944683postfix
postform1556223postform
postgame1345523postgame
postgrad1245493postgrad
posthole1339533posthole
postiche1547793postiche
posties93128813posties
postin83521033post_in
posting105622243posting
postins93721203postins
postique1945873postique
postludes1244623postludes
postman112410043postman
postmark1645433postmark
postmen113110423postmen
postop10511943post_op
postops11311713postops
postoral10311723postoral
postpone1248693postpone
postpose1247653postpose
postpunk1642303postpunk
postrace12310543postrace
posts75228783post__s
posttax1645533posttax
postteen1055693postteen
postulate1169813postulate
posturing1238993posturing
posturist11410443posturist
postwar1236903postwar
potage92715903po_tage
pother113818853po_ther
potpie103412433po_tpie
potsie83916033po_tsie
potstone1039423potstone
pottage103310603pottage
potter83926983potter_
pottered112311663pottered
potterer102310263potterer
potters94024343potters
pottery123011073pottery
pottier93516493pottier
pottle84416103po_ttle
potzer174411213po_tzer
pour611527473po__ur_
poured95116743po__ured
pourer84516043po__urer
pours74623183po__urs
pouter83923983pouter_
pouters94221873pouters
poutier93215323poutier
poutine93316823poutine
powter114116033powter_
powters124015663powters
precure11312553precure
pressure1039773pressure
prestore104217353prestore
procure1138573procure
prostate10314533prostate
prostie91617743prost_ie
prostyle13187273prostyle
puncture1245053puncture
pure65543333p___ure
purpure1195993purpure
pustuled1134953pustuled
pustules1038443pustules
rapture937393rapture
rasure6311423ras_ure
restore75822983restore
rondure837313rondure
roster64329083roster_
rosters73727553rosters
rostra6310933rost_ra
rostrum947223rostrum
rupture966163rupture
soilure736233soilure
stare54440263__stare
stature74410683stature
stere55328543__stere
store56333813__store
stoure64814943__stoure
stupe75217753__stupe
sturt56028963__sturt
sure45447413__s_ure
suture6313203_suture
texture1497083texture
tonsure758783tonsure
tortured935843tortured
torturer835493torturer
tortures838913tortures
unsure62815413uns_ure
upstare9158683upstare
venture10311173venture
vestured1237463vestured
vestures11311043vestures
vulture1036763vulture
wafture1334853wafture
zoster153715853zoster_
zosters163015413zosters

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit1340272806.68620045.9
3Display Results2802800.1102545.5
 (SQL Overall)1786912807.21924752.9
 
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.