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

104 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
tramps10511445(None) 
cramps125615561cramps
gramps114114271gramps
ramps96224631_ramps
tamps95524081t_amps
tramp96319771tramp_
trampy13499251trampy
trams75327671tram_s
traps75727481tra_ps
tromps104911701tromps
trumps104611881trumps
abamps1236252abamps
amps86230342__amps
arames84622572arames
camps116330262_camps
champs154915682champs
clamps124515082clamps
cramp115120692cramp_
crampy154710992crampy
crams96229152cram_s
craps95328642cra_ps
crimps124613452crimps
crumps124514342crumps
damps105220412_damps
dramas95814652dramas
drams86025832dram_s
frames115119862frames
fraps105620552fra_ps
frumps13479782frumps
gamps105323712_gamps
gramas94317202gramas
gramp106218322gramp_
grampa115010172grampa
grampas12399252grampas
grampus12356312grampus
grams85327312gram_s
grasps9489252grasps
grumps114510572grumps
lamps95624832_lamps
prams96125512pram_s
preamps1336612preamps
primps124711822primps
ramp85934002_ramp_
rams65950772_ram_s
ramus76418282_ramus
raps66247732_ra_ps
rasps74316662_rasps
romps94617542_romps
rumps95922292_rumps
samps96124672_samps
scamps125014172scamps
stamps105614022stamps
straps87721782stra_ps
swamps135910262swamps
tames75242012t_ames
tamis76728732t_amis
tamp86133002t_amp_
tams67247932t_am_s
taps66050672t_a_ps
taramas9612702taramas
tarps76527112t_arps
teams75726512team_s
temps95417132t_emps
thumps13449352thumps
traces85329932traces
tracks124818842tracks
tracts85019072tracts
trades75724502trades
tragus749232tragus
traiks104013712traiks
trails64622512trails
trains64725342trains
traipse935872traipse
traits65121982traits
tram67034552tram__
tramel84113712tramel
tramels93812492tramels
tramped124312432tramped
tramper113812162tramper
trampers123210392trampers
trampish1535652trampish
trample11299702trample
tramples122610202tramples
tranks104017762tranks
tranqs155210312tranqs
trans54933042tra_ns
trap67532802tra_p_
trapes85024462trapes
trapt76433392tra_pt
trass56226472tra_ss
traumas938592traumas
traves94222742traves
trawls94412392trawls
trays85623432tra_ys
trims75021472trim_s
trips74923362tr_ips
tromp95815802tromp_
trompe105611262trompe
trompes114111622trompes
troops85712782troops
trump95615122trump_
tumps95420792t_umps
vamps125415482_vamps
wraps105617152wra_ps

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.326548131.9
2DLD Change Limit825511042.53332590.2
3Display Results1041040.0303466.7
 (SQL Overall)1786911042.88961852.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.