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

133 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
soapers9371592(None) 
shapers124016891shapers
soakers114114951soakers
soaper84517871soaper_
soarers74118091soarers
apers76629132__apers
boaters93419242boaters
boppers133911922boppers
capers105428142_capers
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
coopers114019482coopers
copers104629842co_pers
coppers133519752coppers
diapers104713912diapers
dopers95522482do_pers
dorpers104113172dorpers
drapers105313352drapers
escapers12337412escapers
foamers123812102foamers
gapers94520472_gapers
heapers123616672heapers
hoaxers17327132hoaxers
hoopers123616492hoopers
hopers114222972ho_pers
hoppers143115142hoppers
japers154616172_japers
leapers93716662leapers
loaders83413432loaders
loafers10349462loafers
loaners73913622loaners
loopers93914032loopers
lopers84424142lo_pers
loppers113014102loppers
moaners92813552moaners
mopers104220372mo_pers
moppers133412462moppers
oaters65029792_oaters
papers105125322_papers
poppers103414862poppers
rapers84327182_rapers
reapers93520452reapers
roamers93713462roamers
roarers73812742roarers
rompers113412242rompers
ropers84325902ro_pers
sabers85224732s_abers
sakers104125432s_akers
sapors84118812s_apors
sappers113518902sappers
savers93825922s_avers
sawers94620162s_awers
sayers94221592s_ayers
scalers93817262scalers
scalpers123710862scalpers
scampers143611032scampers
scapes105122262scape_s
scarers94618512scarers
scarpers124712512scarpers
scaupers12378172scaupers
scoopers124210192scoopers
scrapers125510532scrapers
sealers74323552sealers
seamers94719432seamers
seaters74028942seaters
shaders115915552shaders
shakers144015562shakers
shaper114119932shaper_
shapes115124952shape_s
sharers104720622sharers
sharpers133810942sharpers
shavers134115092shavers
shoppers153010762shoppers
simpers113014122simpers
sippers113117752sippers
skaters113512962skaters
slakers114115752slakers
slappers123710952slappers
slaters73123732slaters
slavers103716502slavers
slayers104513322slayers
slopers94213092slopers
snappers123510172snappers
snarers74216662snarers
snipers93311772snipers
snoopers10319842snoopers
soaker105717532soaker_
soaped95817972soape_d
soapier93411712soapier_
soapless10278072soapless
soaps75120712soap__s
soarer64522242soarer_
soars54732512soa__rs
soaves94218672soave_s
sobbers114114262sobbers
sobers85218862so_bers
socagers1196362socagers
soccers1138392soccers
solacers10268892solacers
solders83517772solders
solvers104414252solvers
sonders83820712sonders
sooners73916642sooners
sopors85215202so_pors
sorners73416872sorners
sorters74221132sorters
souters74422602souters
sowers94923442so_wers
spacers113813872spacers
spaders104214472spaders
sparers94519612sparers
stagers84116672stagers
stampers124211602stampers
stapes85028732stape_s
staplers103111202staplers
starers74522312starers
staters73922342staters
stayers103813632stayers
stompers123610042stompers
stoopers103711302stoopers
stopers94217372stopers
stoppers123910592stoppers
supers84622402s_upers
suppers113314702suppers
swagers114211022swagers
swampers15317472swampers
swappers15358082swappers
swayers13398852swayers
swoopers13317522swoopers
tapers84025812_tapers
topers85025322to_pers
toppers113914602toppers

Search took 4 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 Filter1786911076710.360496363.9
2DLD Change Limit1076711333.40631612.2
3Display Results1331330.0462891.3
 (SQL Overall)1786911333.81246875.9
 
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.