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

203 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
pours7462318(None) 
fours85521491fours
hours85422391hours
lours55125291lours
ours47237561_ours
poufs105616061poufs
pour611527471pour_
pouts75530321pouts
purs65641041p_urs
sours55230501sours
tours55325891tours
yours85217881yours
amours83512662amours
blurs74619082blurs
boars75229602boars
boors74325012boors
bourg84113842bourg
bourgs9459992bourgs
bourn75518482bourn
bourns84114062bourns
bourse84414332bourse
bouts75131312bouts
burs65847422_burs
clours85215092clours
coirs75221052coirs
cors66656442co_rs
coups95522472coups
course85117782course
court75532772court
courts84216172courts
curs65645542_curs
doers65225712doers
doors65022132doors
dorrs65520592dorrs
dors56747602do_rs
doums85417642doums
dour56330432dour_
doura66518662doura
douras75016722douras
flours94414052flours
fouls87221432fouls
four76226862four_
furs76735042_furs
gaurs66317992gaurs
goers65520252goers
gourd71011902gourd
gourds8108252gourds
gouts64826172gouts
hoars85925552hoars
hoers85724922hoers
hour75827312hour_
houri85915252houri
houris94514582houris
inpours936422inpours
jouks165612342jouks
knurs94511152knurs
kors85933012ko_rs
kouros1039182kouros
louis57322322louis
loups75319622loups
lour45430682lour_
loury85716752loury
louts56330272louts
mohurs1135932mohurs
moors74923142moors
mors65950062mo_rs
moues75732842moues
mourn77215012mourn
mourns84111012mourns
noirs55615462noirs
nouns56717312nouns
nous46136982nou_s
oars46846032_oars
odours7418252odours
opus66420592opu_s
ors35750112_o_rs
ouds56430102_ouds
our36042892_our_
outs45746962_outs
pairs75325832pairs
parrs75928672parrs
pars67560792p_ars
pears75138612pears
peers75130272peers
phuts104613502phuts
piers75926332piers
pious74621272piou_s
plugs85213492plugs
plums94619952plums
plus66324832plu_s
pocks135022962pocks
pods76540152po_ds
poems95715552poems
poets76024442poets
pois66539042po_is
pokers124617922pokers
pokes116133012pokes
polars84419352polars
polers84225642polers
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562po_ls
polys105718762polys
pomes94833932pomes
pomos95321582pomos
pomps115316192pomps
poms87037742po_ms
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602po_ns
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poor65630222poor_
poori74816232poori
pooris83916842pooris
poos65949112po_os
popes95933812popes
pops86340952po_ps
pore66451262po_re
pores75849032pores
pork106929682po_rk
porks115124142porks
porn65636022po_rn
porns75527342porns
port66059632po_rt
ports75934592ports
posers84223972posers
poses74642762poses
poseurs9378292poseurs
posts75228782posts
pots66452362po_ts
pouch124617082pouch
pouf95732642pou_f
pouff135215422pouff
pouffs14418122pouffs
poult76928872poult
poults84613482poults
pound84417862pound
pounds93714382pounds
poured95116742poured
pourer84516042pourer
pourers93513672pourers
pout65752552pou_t
pouters94221872pouters
pouty107018812pouty
powers113822322powers
pows95537662po_ws
poxes145325722poxes
pubs85029212p_ubs
puds75630512p_uds
pugs76332772p_ugs
puls65437562p_uls
puns66641482p_uns
pups86032232p_ups
pur56840552p_ur_
pure65543332p_ure
puri65931442p_uri
puris75332022p_uris
purl65631422p_url
purls74723352p_urls
purr64925812p_urr
purrs75320432purrs
purse76028892p_urse
pursy105016412p_ursy
pus55547842p_u_s
puss64830132p_uss
puts65641752p_uts
repours9310232repours
roars55622242roars
roues56039352roues
roups75118902roups
routs57133412routs
sapours93610622sapours
scours84913592scours
slurs54123372slurs
soars54732512soars
sorus54527582sorus
souks94820522souks
souls55127362souls
soups75322942soups
sour45935892sour_
sous46947212sou_s
spoors84014032spoors
spouts85115112spouts
spurs74621522spurs
stours65015632stours
torrs53923562torrs
tors46157382to_rs
torus54329762torus
tour45530382tour_
touts54830392touts
vapours12277462vapours
your78623432your_
yourn87512772yourn
yous76230652you_s
zouks184410502zouks

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.0931921408.6
2DLD Change Limit538002031.90628226.7
3Display Results2032030.0603383.3
 (SQL Overall)1786912032.05986785.3
 
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.