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 “powter” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
powter11411603(None) 
pewter114013671pewter
porter84224411porter
poster84129171poster
potter83926981potter
pouter83923981pouter
powder123611901powder
power105325951pow_er
powters124015651powters
boater84622092boater
bolter83920752bolter
bower107328182bow_er
bowler114217312bowler
bowyer14368922bowyer
coater84329552coater
colter84625092colter
cooter85128612cooter
copter109822012copter
coster84331292coster
cotter84926672cotter
couter84930202couter
cower104531772cow_er
cowier113616162cowier
doter65428622do_ter
dotter74419342dotter
dower95027702dow_er
downer104414922downer
dowser104716082dowser
footer94320772footer
foster94322222foster
fowler123712582fowler
goiter74116202goiter
hooter94123922hooter
hotter94720072hotter
howler123514312howler
jolter133513092jolter
jotter134315632jotter
lofter94614722lofter
loiter64619172loiter
looter64222322looter
lotter64025602lotter
lower85830412low_er
molter84119422molter
mooter83921092mooter
mower104523452mow_er
noter55025642no_ter
oater55433732_oater
ofter84116872_ofter
otter54423972_otter
outer55633302_outer
owner84613312_owner
oxter123414092_oxter
palter84423262palter
paster85734372paster
pater74740722p_ater
patter84628262patter
pawer104422972paw_er
pawner114212922pawner
pelter83321622pelter
perter84422282perter
pester84827592pester
peter74427592p_eter
petter83924772petter
pewters124113352pewters
plater84427692plater
plotter94113662plotter
plower114315062plow_er
pointer93814932pointer
poiser84217242poiser
poker115122882po_ker
pokier124914632pokier
polder94019252polder
poler74431792po_ler
politer92417072politer
poller83921852poller
ponder94521692ponder
pontes83627852pontes
poofter1237162poofter
pooler83819842pooler
poorer82613992poorer
popper93615962popper
porker124917542porker
ported94223242ported
porters93722702porters
poser75128772po_ser
posher115018162posher
posted93722492posted
postern93615602postern
posters93927992posters
pother113818852pother
potted94624012potted
potters94024342potters
pottery123011072pottery
pottier93516492pottier
potzer174411202potzer
poulter93712012poulter
pourer84516042pourer
pouted94021392pouted
pouters94221862pouters
poutier93215322poutier
powders134111552powders
powdery16396122powdery
powers113822322pow_ers
poxier153812112poxier
prater84825352prater
prower114218122prow_er
prowler123310012prowler
punter84320022punter
putter83921442putter
rooter64926032rooter
roster64329082roster
rotter64325462rotter
router65025842router
rower85430492row_er
softer94015312softer
sorter64425082sorter
souter64225922souter
sower85229312sow_er
sporter93616552sporter
spotter94514872spotter
spouter94213222spouter
tooter64420802tooter
toter55932132to_ter
totter65021462totter
touter63821032touter
tower85729202tow_er
voter85121052vo_ter
vower115220792vow_er
wowser125110202wowser
yowler123310042yowler
zoster153715852zoster

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 Filter178691825510.233766914.2
2DLD Change Limit825511315.31315537.5
3Display Results1311310.0761723.7
 (SQL Overall)1786911315.62231784.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.