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

182 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
poohs10391571(None) 
oohs75220691_oohs
poods85124751poods
poofs105222791poofs
pooh96027381pooh_
pools74427701pools
poons75430971poons
poops94422411poops
poos65949111poo_s
bohos105618252bohos
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032boo_s
booths115313792booths
boots75837972boots
cohos105921852cohos
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492coo_s
coots75636842coots
dooms85321342dooms
doors65022132doors
epochs1335812epochs
foods95924162foods
fools86824202fools
foots85528282foots
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912goo_s
goths96513002goths
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830252hoots
kooks85217262kooks
kophs145010932kophs
lochs106715512lochs
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122loo_s
loots55431422loots
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302moo_s
moots75831662moots
moths106021552moths
nooks95420392nooks
noons54125282noons
ohs66232312__ohs
ooh67637092_ooh_
oops65232672_oops
oots46446442_oots
opahs105411982opahs
paths105521382paths
pechs125516202pechs
pehs95625762p_ehs
peons75327182peons
phons105221142phons
phots105418502phots
pions75826392pions
pious74621272pious
piths105817542piths
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
poboys1397312poboys
pocks135022962pocks
pods76540152p_ods
poems95715552poems
poets76024442poets
poh86740532p_oh_
pois66539042p_ois
pokes116133012pokes
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562p_ols
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742p_oms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602p_ons
poo57757112poo__
pooch124815302pooch
pooches143214162pooches
pood75934322poo_d
pooed85226242pooed
poof95541662poo_f
poofy136213272poofy
poohed123912522poohed
pool65835952poo_l
poon67341262poo_n
poop86532812poo_p
poor65630222poo_r
poori74816232poori
pooris83916842pooris
poove104514302poove
pooves113914712pooves
popes95933812popes
pops86340952p_ops
pores75849032pores
porks115124142porks
porns75527342porns
porous84419482porous
ports75934592ports
poses74642762poses
posh95427322posh_
posts75228782posts
pothos114214692pothos
pots66452362p_ots
poufs105616062poufs
pours74623182pours
pouts75530322pouts
pows95537662p_ows
poxes145325722poxes
poyous112911622poyous
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
proofs114511682proofs
props95726882props
pros65742782pro_s
pross76529402pross
prows106327012prows
psoas75012982psoas
qophs19507812qophs
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
sooks94425452sooks
sooths95715592sooths
soots55536212soots
sophs104916022sophs
soths86218632soths
spoofs114011812spoofs
spooks124312932spooks
spools85115912spools
spoons84116022spoons
spoors84014032spoors
tools55325242tools
toons55027532toons
tooths96013802tooths
toots55331872toots
tophs105220052tophs
woods95723032woods
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802woo_s
woosh113710732woosh
yodhs12669012yodhs
yoghs125410592yoghs
zooks184716942zooks
zooms164415522zooms
zoons144919692zoons
zoos135828802zoo_s

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001821.65332546.9
3Display Results1821820.0632888.9
 (SQL Overall)1786911822.02988068.5
 
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.