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

112 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
scamp11571731(None) 
camp106336451_camp
samp85733591s_amp
scalp95217981scalp
scam85932351scam_
scampi12469101scampi
scamps125014171scamps
scams94423971scams
scarp95724101scarp
scaup95515991scaup
stamp95217361stamp
swamp125015321swamp
abamp11310602abamp
amp77541022__amp
cam78058982_cam_
came87648752_came
camo85731752_camo
campi116217782_campi
campo115219762_campo
camps116330262_camps
campy145116182_campy
cams87047282_cams
cap76758982_ca_p
carp85139812_carp
champ145017962champ
clamp115517652clamp
comp106731252_comp
cramp115120692cramp
damp96228842_damp
decamp1338452decamp
encamp1235942encamp
escarp10449002escarp
gamp98833212_gamp
gramp106218322gramp
lamp86233822_lamp
ramp85934002_ramp
salp64534092s_alp
same65245642s_ame
samps96124672s_amps
sap56463232s_a_p
scab85926712sca_b
scabs94818642scabs
scad75725762sca_d
scads85419952scads
scag76626892sca_g
scags85520972scags
scald84818122scald
scale74629142scale
scall74420372scall
scalps104315232scalps
scaly104718722scaly
scamped144711962scamped
scamper134613162scamper
scan65530452sca_n
scans74625102scans
scant79735072scant
scape96921842scape
scar66434202sca_r
scare75334462scare
scarf105427142scarf
scarph13429602scarph
scarps104718602scarps
scars75433532scars
scart76139772scart
scary105222592scary
scat65848372sca_t
scats75930602scats
scatt76030092scatt
scaups105411932scaups
scaur75814902scaur
schmo124510202schmo
scoop95617162scoop
scop85925522sc_op
scram910621612scram_
scrams105216622scrams
scrap97120402scrap
scrimp125110582scrimp
scrip96619192scrip
sculp95314842sculp
scum85924522scum_
scums95017422scums
scup84822382sc_up
seam66645972seam_
seams75731662seams
seamy105921272seamy
sham96436352sham_
shame105726702shame
shams105829412shams
sharp104922532sharp
simp85228772s_imp
skimp135411312skimp
slam67737972slam_
slams74927902slams
slap66434042sla_p
slump94816632slump
snap65727032sna_p
soap65831132soa_p
spam85930042spam_
spams94922192spams
stamps105614022stamps
stomp95616662stomp
stump94616462stump
sump86331532s_ump
swam96329982swam_
swami105614522swami
swamps135910262swamps
swampy16437232swampy
swamy136714402swamy
swap95925432swa_p
tamp86133002_tamp
tramp96319772tramp
vamp115521542_vamp

Search took 2 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.0762351197.4
2DLD Change Limit538001121.68631909.8
3Display Results1121120.0333393.9
 (SQL Overall)1786911121.79599549.3
 
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.