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 “soaped” 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
soaped9581797(None) 
scaped115519551scaped
shaped125020101shaped
soaked114717591soaked
soaper84517871soaper
soared74324291soared
sopped114819901sopped
souped95017671souped
aped78538152__aped
boated94221972boated
bopped134413402bopped
caped104931802_caped
coaled95022702coaled
coapted123911492coapted
coated94927032coated
coaxed165612512coaxed
comped135919872comped
cooped114821602cooped
coped105036842co_ped
copped135221252copped
couped115019312couped
craped116120522craped
doated84118182doated
doped95326712do_ped
draped105314362draped
escaped12388852escaped
foaled104515962foaled
foamed126014402foamed
fopped144012672fopped
gaped96123532_gaped
goaded94913712goaded
goaled85014352goaled
heaped124516902heaped
hoaxed17378872hoaxed
hooped125518182hooped
hoped115628182ho_ped
hopped144318112hopped
japed156217632_japed
leaped94317772leaped
loaded84616872loaded
loafed104011152loafed
loamed94414612loamed
loaned73816292loaned
looped95217172looped
loped85128332lo_ped
lopped114218622lopped
louped95316382louped
moaned94514172moaned
moated94819002moated
moped105424732mo_ped
mopped134114322mopped
oared65030652_oared
oped76230152_o_ped
pooped113915942pooped
popped104117812popped
raped85334622_raped
reaped94122452reaped
roamed95215092roamed
roared75015392roared
romped114513652romped
roped84630802ro_ped
rouped95717352rouped
sabed86526812s_abed
saned65636272s_aned
sapid84720932s_apid
sapped114422012sapped
sated66238532s_ated
saved95127112s_aved
sawed95628402s_awed
sayed96127142s_ayed
scaled94822442scaled
scalped124411992scalped
scamped144711962scamped
scape96921842scape_
scapes105122262scapes
scared95227292scared
scarped124314392scarped
scooped124611742scooped
scoped115116652scoped
scraped124313132scraped
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seated75131052seated
seeped94317522seeped
shaded114518872shaded
shaled105023952shaled
shamed125120212shamed
shape105125112shape_
shapen114414652shapen
shaper114119932shaper
shapes115124942shapes
shared105829062shared
sharped134112042sharped
shaved135118382shaved
shawed134817232shawed
shoaled113810962shoaled
shopped153512202shopped
siped84927682s_iped
sipped113720632sipped
skated114414872skated
skoaled12226042skoaled
slaked114318272slaked
slapped123511842slapped
slated75028312slated
slaved104017042slaved
slayed104716222slayed
sliped95417062sliped
sloped94216852sloped
slopped123511442slopped
snaked115017592snaked
snapped124611202snapped
snared74824552snared
snawed104813732snawed
sneaped10338812sneaped
sniped94913482sniped
snooped103711812snooped
soaker105717532soaker
soap65831132soap__
soapers93715922soapers
soapier93411712soapier
soaps75120712soap_s
soapy106114782soap_y
soarer64522242soarer
soave84219052soave_
soaves94218672soaves
sobbed113516262sobbed
socked134721502socked
sodded94113302sodded
sofabed1334332sofabed
sogged95518522sogged
soiled73822472soiled
solaced102911062solaced
solated83618022solated
soled65835172so_led
soloed74515742soloed
solved105312932solved
sooted73922582sooted
sorbed94916512sorbed
sored66141782so_red
sorned74820042sorned
sorted74523712sorted
sotted74121392sotted
souled75419822souled
soured74921862soured
soused74822982soused
sowed94933862so_wed
spaced114517252spaced
spaded103816752spaded
spaed85522272spa_ed
spared95427482spared
spayed124213612spayed
sped76031492s__ped
staged84521562staged
staked114621942staked
staled74728102staled
stamped124812812stamped
staned74824642staned
stapes85028732stapes
stapled103613692stapled
stared75429872stared
stated75427832stated
staved103918052staved
stayed104817272stayed
stiped94517072stiped
stomped124110532stomped
stooped103813832stooped
stoped94721012stoped
stopped124512202stopped
supped114415702supped
swaged114212252swaged
swamped15498442swamped
swapped15429142swapped
swayed133510262swayed
swiped123811092swiped
swooped13418752swooped
swopped15437672swopped
taped85327422_taped
toped85631312to_ped
topped114617722topped
woaded115211602woaded

Search took 5 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.250714764.0
2DLD Change Limit825511824.00020637.8
3Display Results1821820.1401300.0
 (SQL Overall)1786911824.39040704.1
 
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.