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

143 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
posturing123899(None) 
pasturing1238431pasturing
costuming1445282costuming
fostering132411262fostering
gesturing1136652gesturing
pastoring12310852pastoring
pestering122315662pestering
picturing1436032picturing
portering122012302portering
posting105622242post__ing
posturist11410442posturist
pottering122612002pottering
pouring103115862po__uring
torturing1036252torturing
vesturing1337202vesturing
assuring937773_assuring
bolstering1346883bolstering
bowstring15165123bowst_ring
capturing1436623capturing
closuring1255173clos_uring
cloturing1245473cloturing
colouring1258733colouring
conjuring1937913conjuring
construing1347443construing
contouring1347013contouring
contusing1239143contusing
coshering15510023coshering
costarring1345393costarring
costing104323023cost__ing
culturing1236553culturing
disturbing1445653disturbing
doctoring1346183doctoring
ensuring9310173ens_uring
featuring1337323featuring
festering132413173festering
fissuring1344813fissuring
fortuning1345493fortuning
fosterling1445173fosterling
holstering1447083holstering
honouring1336883honouring
hosteling1337893hosteling
hosting114318383host__ing
insuring9311153ins_uring
jointuring1843233jointuring
jostling16207123jost_ling
koshering1735363koshering
lecturing1237303lecturing
lobstering1345123lobstering
loitering1039683loitering
louring83916503lo__uring
lustering102711203lustering
lustring9269723lust_ring
mastering122315303mastering
maturing1139963_maturing
mistuning1237673mistuning
mortaring1237943mortaring
motoring11410953mo_toring
mustering122212333mustering
nonjuring1756053nonjuring
nurturing1045013nurturing
obscuring1444023obscuring
outring84021023_out_ring
oystering1337563oystering
paltering122612893paltering
pasting103826553past__ing
pattering122314423pattering
peltering122011673peltering
perduring1336013perduring
perjuring1944923perjuring
perturbing1543563perturbing
pestling111010253pest_ling
petering112516813p_etering
pistoling1268493pistoling
plastering1339243plastering
poetising1238713poetising
poetizing2148683poetizing
polluting1235703polluting
pondering132411333pondering
poring94227273po___ring
portaging1346843portaging
porting103021783port__ing
posing93922643pos___ing
positing11312303pos_iting
postburn1243923postbur_n_
postdating1447163postdating
postdrug1243093postdr_ug
posterior1147833posterior
posterity1448693posterity
postern93615613poster_n_
posterns102713723poster_ns
postfixing2343243postfixing
postforming1953263postforming
postin83521033post__in_
postings112912303post__ings
postins93721203post__ins
postmarking2053693postmarking
postmating1548603postmating
postponing1555743postponing
postposing1555023postposing
postriot10412253post_riot
posttrial1146513posttrial
postulant1147313postulant
postulating1447503postulating
postural1049203postur_al
posture9313253postur__e
postured1139493postur_ed
posturer1038923postur_er
posturers1137053posturers
postures10313783postur_es
posturists1247073posturists
pothering151911283pothering
potting103720893po_t_ting
pouting103519943po__uting
powdering16246503powdering
powering142210803po_wering
precuring1439423precuring
pressuring1346513pressuring
prestoring13310303prestoring
proctoring1546673proctoring
procuring1437993procuring
prospering1547173prospering
puncturing1543303puncturing
puttering122611643puttering
rapturing1245363rapturing
restoring10314613restoring
restring91518783rest_ring
roistering1148583roistering
roystering1445413roystering
rupturing1244353rupturing
sistering101213753sistering
souring83219063__souring
staring84527053__staring
storing83921123__storing
string75327563__st_ring
suturing9310373_suturing
texturing1735223texturing
tonsuring1046503tonsuring
tottering10229613tottering
touring82915193to__uring
unstring9312093unst_ring
upstaring1235963upstaring
venturing1337553venturing
westering132112643westering

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411436.47022973.9
3Display Results1431430.0602383.3
 (SQL Overall)1786911436.95025710.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.