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 “tramcar” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
tramcar113559(None) 
tramcars1245231tramcars
grammar12406892grammar
tracer84820232tra_cer
tramper113812162tramper
tramway1544862tramway
trocar848772tr_ocar
bracer104620583bra_cer
calcar10312753_calcar
crammer134010963crammer
damar84117743_dam_ar
dammar11438903_dammar
drama85117423dram_a_
dramas95814663dram_as
drawbar13103193drawbar
flatcar1274613flatcar
fracas11311993fra_cas
framer114817443fram_er
grama85620283gram_a_
gramary1355913gram_ary
gramas94317203gram_as
gramma11499803gramma_
grammars13345943grammars
grammas12499773grammas
grampa115010173grampa_
grampas12399253grampas
lascar868573_lascar
prancer113613383prancer
racer75233023_ra_cer
radar61316723_ra_dar
railcar945483_railcar
ramal74622243_ram_al
rammer103519653_rammer
rampart11311993_rampart
rancor8810373_rancor
rascal8511123_rascal
sambar103914163_sambar
talar56225383t_a_lar
tamal73522623t_am_al
tamari8313413t_am_ari
tambac122210243t_ambac
tambak14249263t_ambak
tambur10358713t_ambur
tamer75230103t_am_er
tampan102512323t_ampan
tamper104618513t_amper
tarama8412733taram_a_
taramas9612703taram_as
tarmac10310333tarm_ac
tarmacs1138323tarmacs
tartar63214753t_artar
tatar56122063t_a_tar
teacart91113193tea_cart
tomcat101013453t_omcat
trace75829613tra_c_e
traced94821583tra_ced
tracers94917843tra_cers
tracery12399793tra_cery
traces85329933tra_ces
track114823013tra_c_k
tracker133515173tracker
tracks124818843tra_cks
tract75635713tra_c_t
tractor9311343tractor
tracts85019073tra_cts
trader75218763tra_der
traducer1144583traducer
tragical1148213tragical
trailer73015393trailer
trainer73316793trainer
traitor7310123traitor
tram67034553tram___
tramel84113713tram_el
tramell9398703tramell
tramels93812493tramels
trammed123810713trammed
trammel11357663trammel
tramp96319773tram__p
tramped124312433tramped
trampers123210393trampers
trampier12318243trampier
trample11299703trample
trampler12278013trampler
tramps105114453tram_ps
trampy13499253tram_py
tramroad1143763tramroad
trams75327673tram__s
tramways1643723tramways
trance84718763tranc_e
tranced104414173tranced
trances93919643trances
tranche123312223tranche
trangam1039363trangam
trapan82412973tra_pan
trapper113912803trapper
trasher104416133trasher
trauma838803trauma_
traumas938593traumas
trawler104011903trawler
tremor84210403trem_or
trimer85717153trim_er
trimmer113610833trimmer
trocars959043tr_ocars
trochar1257073trochar
trumeau944163trumeau
tryma1037223trym_a_
turbocar1243363turbocar

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271076.20321606.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.67226782.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.