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

151 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
pooler8381984(None) 
cooler84824711cooler
poler74431791p_oler
poller83921851poller
pooled94619811pooled
poolers94217421poolers
poorer82613991poorer
spooler93711381spooler
tooler63818611tooler
wooler93615871wooler
boiler84319272boiler
boodler103312002boodler
booger94816552booger
booker124719192booker
boomer104618512boomer
boozer174815962boozer
bowler114217312bowler
choler113717152choler
coaler84121702coaler
coiler84421592coiler
cooer74831012coo_er
cooker124722452cooker
cooled95224582cooled
coolers93522492coolers
cooper104221122cooper
cooter85128612cooter
doodler93310152doodler
doolee73018952doolee
doozer163910462doozer
fooled104317822fooled
foolery1336692foolery
footer94320772footer
footler104011872footler
foozler19397592foozler
fouler93614902fouler
fowler123712582fowler
gaoler73913572gaoler
goober93911742goober
gooier73516212gooier
holler93520612holler
hoofer124014952hoofer
hooker134820172hooker
hooper114518312hooper
hooter94123922hooter
hoover124314432hoover
howler123514312howler
loller63315282loller
looker104816952looker
looper83817112looper
looser65219942looser
looter64222322looter
moiler84017262moiler
mooley11311632mooley
mooner85317832mooner
mooter83921092mooter
nobler83713452nobler
nooser65517822nooser
ogler65917442_ogler
oiler54628282_oiler
paler75436932p_aler
pedler93614612pedler
peeler83517382peeler
peopler1138072peopler
piolet83225642piolet
plover115312612plover
plower114315062plower
poiser84217242poiser
poker115122882p_oker
pokier124914632pokier
polar75623452p_olar
polder94019252polder
pole65951302p_ole_
poled84934842p_oled
polers84225642p_olers
poles75351002p_oles
polled94022002polled
pollee83623272pollee
pollen83416452pollen
pollers93420022pollers
pollex153711162pollex
ponder94521692ponder
poodle93112042poodle_
poodles103013512poodles
pooed85226242poo_ed
poofter1237162poofter
poohed123912522poohed
pool65835952pool__
pools74427702pool_s
pooped113915942pooped
poor65630222poo__r
poove104514302poove_
pooves113914712pooves
poplar103611112poplar
popover1495842popover
popper93615962popper
porker124917542porker
porter84224412porter
poser75128772p_oser
posher115018162posher
posole8314222posole_
posoles9314882posoles
poster84129172poster
pother113818852pother
potter83926982potter
potzer174411202potzer
poulter93712012poulter
pourer84516042pourer
pouter83923982pouter
powder123611902powder
power105325952p_ower
powter114116032powter
poxier153812112poxier
pozole1758912pozole_
pozoles1839062pozoles
prober104516072prober
prole74527792prole_
proleg94612112proleg
proles84627202proles
proofer12149102proofer
proper104319952proper
proser84223462proser
prover113819722prover
prower114218122prower
prowler123310012prowler
puler74826622p_uler
puller83820812puller
roller63919792roller
roofer94415282roofer
roomer84718632roomer
rooser63921882rooser
rooter64926032rooter
sooner64220462sooner
spoiler93310682spoiler
spoofer12368722spoofer
spooled104613522spooled
spoolers10349362spoolers
toiler63918282toiler
toller63819442toller
tooled74918902tooled
toolers74416502toolers
tooter64420802tooter
tootler73511122tootler
wooer84316692woo_er
woofer124411362woofer
wooled103715502wooled
woolen93111372woolen
woolers104214022woolers
woolier103612352woolier
yodler10389942yodler
yowler123310042yowler
zooier153411232zooier

Search took 9 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.236757165.3
2DLD Change Limit825511517.37311196.4
3Display Results1511510.156967.9
 (SQL Overall)1786911517.76523012.4
 
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.