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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
tramcars124523(None) 
tramcar1135591tramcar_
grammars13345942grammars
tracers94917842tra_cers
trampers123210392trampers
tramways1643722tramways
trocars959042tr_ocars
bracers114616703bra_cers
calcars11312653_calcars
crammers14369353crammers
damars93815003_dam_ars
dammars12308193_dammars
dramas95814663dram_a_s
drawbars1483103drawbars
flatcars1344623flatcars
fracas11311993fra_ca_s
framers125113823fram_ers
gramary1355913gram_ary
gramas94317203gram_a_s
grammar12406893grammar_
grammas12499773gramma_s
grampas12399253grampa_s
lascars979013_lascars
prancers123210333prancers
racers84725433_ra_cers
radars71314673_ra_dars
railcars1045313_railcars
rammers113715043_rammers
rampart11311993_rampart
ramparts1245583_ramparts
rancors9811373_rancors
rascals959663_rascals
sambars115113843_sambars
talars66021683t_a_lars
tamals84116633t_am_als
tamari8313413t_am_ari
tamaris9413603t_am_aris
tambacs13219363t_ambacs
tambaks15218153t_ambaks
tamburs11288613t_amburs
tamers84224033t_am_ers
tampans113310983t_ampans
tampers113516743t_ampers
taramas9612703taram_a_s
tarmacs1138323tarm_acs
tartars73313403t_artars
tatars64619793t_a_tars
teacart91113193tea_cart
teacarts10116073tea_carts
tomcats11127773t_omcats
tracer84820233tra_cer_
tracery12399793tra_cery
traces85329933tra_c_es
trackers143512853trackers
tracks124818843tra_c_ks
tractors10312573tractors
tracts85019073tra_c_ts
traders84316953tra_ders
traducers1243723traducers
trailers82912923trailers
trainers83114643trainers
traitors8310793traitors
tramells10327833tramells
tramels93812493tram_els
tramless1037503tramless
trammels12295413trammels
tramper113812163tramper_
tramplers13305883tramplers
tramples122610203tramples
tramps105114453tram__ps
tramroads1243003tramroads
trams75327673tram___s
tramway1544863tramwa_y
trances93919643tranc_es
tranches132915513tranches
trangams1147203trangams
trapans92812463tra_pans
trappers123711043trappers
trashers113013643trashers
traumas938593trauma_s
trawlers113310203trawlers
tremors93711233trem_ors
trimers94615143trim_ers
trimmers12288913trimmers
trocar848773tr_ocar_
trochars1377853trochars
turbocars1343073turbocars

Search took 8 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 Filter1786911461620.440406115.9
2DLD Change Limit146162877.46619577.0
3Display Results87870.0501740.0
 (SQL Overall)178691877.95622459.9
 
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.