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

114 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
stamps10561402(None) 
samps96124671s_amps
scamps125014171scamps
stamp95217361stamp_
stomps105612831stomps
stumps104912281stumps
swamps135910261swamps
tamps95524091_tamps
abamps1236252abamps
amps86230342__amps
ataps76414832ata_ps
camps116330262_camps
champs154915682champs
clamps124515082clamps
cramps125615562cramps
damps105220412_damps
gamps105323712_gamps
gramps114114272gramps
lamps95624832_lamps
ramps96224632_ramps
restamps1234702restamps
salps74423242s_alps
samp85733592s_amp_
saps65346372s_a_ps
scalps104315232scalps
scamp115717312scamp_
scampi12469102scampi
scams94423972scam_s
scarps104718602scarps
scaups105411932scaups
seams75731662seam_s
shamas113717942shamas
shames114726222shames
shamos114216982shamos
shams105829412sham_s
shamus114112812shamus
sharps115516082sharps
simps94719762s_imps
skimps14488042skimps
slams74927902slam_s
slaps76025712sla_ps
slumps104313582slumps
snaps74719562sna_ps
soaps75120712soa_ps
spams94922192spam_s
stabs76221382sta_bs
stacks124317262stacks
stades74626242stades
staffs12349752staffs
stages75629492stages
stags66226742sta_gs
staigs75414812staigs
stains64923652stains
stairs65416332stairs
stakes103927292stakes
stales65538292stales
stalks104614552stalks
stalls64019932stalls
stamen84115942stamen
stamens93411482stamens
stamped124812812stamped
stamper113714402stamper
stampers124211602stampers
stands75118052stands
stanes64933402stanes
stangs75018172stangs
stanks104917702stanks
stapes85028732stapes
staph104314652sta_ph
staphs114411032staphs
stares66038752stares
stars55836572sta_rs
starts65423122starts
stases64225562stases
stasis63116872stasis
states64337082states
stats55933362sta_ts
status65515212status
staves94525192staves
stays86022022sta_ys
steams84916902steam_s
steeps85215192steeps
stems75219952stem_s
steps76619882st_eps
stimes85920572stimes
stirps85011822stirps
stomas84816322stomas
stomp95616662stomp_
stoops85917892stoops
stops74827282st_ops
stoups85313272stoups
stowps115710582stowps
straps87721782straps
streps86218062streps
strips85719652strips
strops86220382strops
stump94616462stump_
stumpy13458132stumpy
stums75320082stum_s
sumps95023432s_umps
swamis114212292swamis
swamp125015322swamp_
swampy16437232swampy
swaps104819202swa_ps
tames75242012_tames
tamis76728732_tamis
tamp86133012_tamp_
tams67247932_tam_s
taps66050682_ta_ps
tarps76527122_tarps
temps95417132_temps
tramps105114452tramps
tumps95420792_tumps
vamps125415482_vamps

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 Filter178691825510.330541487.9
2DLD Change Limit825511142.21637252.3
3Display Results1141140.0502280.0
 (SQL Overall)1786911142.59668833.2
 
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.