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

129 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
simper10361629(None) 
jimper17389861jimper
limper104117851limper
simmer104115351simmer
simpers113014121simpers
simpler112910861simpler
sipper103920991sipper
aimer75926822aim_er
bumper123714342bumper
camper124722212camper
crimper136510422crimper
damper114117752damper
diaper94513112diaper
dimer85625602dim_er
dimmer114112612dimmer
dipper114017792dipper
dumper114615212dumper
gimped123911472gimped
gimpier12247942gimpier
gipper114215302gipper
hamper134518652hamper
hipper133818022hipper
humper134115882humper
imped105117982_imped
impel95711772_impel
jumper173612372jumper
kipper143414212kipper
limber104316792limber
limier83518722limier
limmer104314792limmer
limner84112872limner
limped114817122limped
limpers113815222limpers
limpet103518632limpet
lipper104219632lipper
lisper84114432lisper
lumper103816652lumper
mimer94825762mim_er
mumper123513522mumper
nipper103715712nipper
pamper124316662pamper
pimped134913482pimped
piper96523192pi_per
pumper124415552pumper
rimer75429242rim_er
rimier83916272rimier
rimmer103516032rimmer
riper74328402ri_per
ripper103518652ripper
romper104213682romper
sampler113212012sampler
sapper103822352sapper
scamper134613162scamper
scrimper1455762scrimper
sempre102710092sempre
shaper114119932shaper
shimmer143310872shimmer
shipper143514042shipper
shrimper1544412shrimper
sicker124023902sicker
sidler74716962sidler
sifter94516232sifter
sigher103813702sigher
signer74015632signer
siker95326032si_ker
siller64026062siller
silver93815812silver
simar74920812sim_ar
simmers113314612simmers
simnel857022simnel
simp85228772simp__
simpered1338252simpered
simperer1237172simperer
simple104315172simple
simples113014942simples
simplex18256392simplex
simply133010522simply
simps94719762simp_s
singer74227312singer
sinker103620902sinker
sinner64320602sinner
sinter63625922sinter
sipe67341042si_pe_
siped84927682si_ped
sipes76036952si_pes
sipped113720632sipped
sippers113117752sippers
sippet103519392sippet
sister64421582sister
sitter63323382sitter
siver85728612si_ver
sizer145521812si_zer
sizier1514813392sizier
skimmer15327532skimmer
skimped16256222skimped
skimpier1634292skimpier
skipper15339572skipper
slimier93212012slimier
slimmer114211342slimmer
slipper113712982slipper
sloper84615912sloper
smiler83916682smiler
smiter83616412smiter
sniper84413642sniper
snipper113911332snipper
soaper84517872soaper
somber103714002somber
stamper113714402stamper
stomper114111232stomper
stoper84320102stoper
stumper113610092stumper
summer104017712summer
sumpter1138872sumpter
super74924482s_uper
supper104115432supper
swamper14349312swamper
swimmer14297652swimmer
tamper104618512tamper
temper103914092temper
timber104012682timber
timer75626042tim_er
tipper103918412tipper
vamper134212652vamper
viper105017302vi_per
whimper17297722whimper
wimped144211512wimped
wimpier14248052wimpier
wiper105421292wi_per
zipper193813122zipper

Search took 6 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.706253103.4
2DLD Change Limit825511294.93616724.3
3Display Results1291290.0462804.3
 (SQL Overall)1786911295.68831415.4
 
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.