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

91 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
tetramer104681(None) 
tetramers1146461tetramers
betrayer1345642betrayer
metamer1139612met_amer
retracer101411882retracer
termer85717252te_r_mer
tetrameric1454312tetrameric
tetrameter1255202tetrameter
betrayed1436303betrayed
betrayers1445013betrayers
bewrayer1643733bewrayer
centraler1146683centraler
defamer132710323de_famer
defoamer14276213defoamer
defrayer1534933defrayer
degrader11247913degrader
depraver1435413depraver
eraser64216333_e_raser
extremer1744653extremer
framer114817443__framer
metamere1257353met_amere
metamers1249623met_amers
petnaper1243913petnaper
petrale9312623petrale_
petrales10312983petrales
reamer84325213re__amer
redrawer1235313redrawer
reframe1239393reframe_
reframed1437853reframed
reframes1338993reframes
retaker113714313ret_aker
retarder9229433retarder
reteamed1138013reteamed
retrace91417343retrace_
retraced111413023retraced
retracers11149553retracers
retraces101417273retraces
retreater9310203retreater
seamer84223613se__amer
steamer93313093_steamer
strafer103912463_strafer
strayer104312503_strayer
streamer10239513_streamer
tamer75230103__t_amer
teamaker1445113teamaker
teamed95418593te__amed
tearer64822903te__arer
tearier73815613tear_ier
teaser65421523te__aser
teemer85515743te__emer
teenager9115293teenager
tentmaker1543113tentmaker
termed94816703te_r_med
termers95414503te_r_mers
termor84412513te_r_mor
terrace93311843terrace_
terraced11318123terraced
terraces102712253terraces
terrae62915213terra_e_
terrane72814233terrane_
terranes82514433terranes
terrases82111483terrases
terrier73414963te_rrier
terser67317823te_r_ser
tetchier1336453tetchier
tether93716103tet__her
tetra53417953tetra___
tetracid1147263tetracid
tetrad73612053tetra__d
tetradic1145813tetradic
tetrads82910193tetra_ds
tetragon945273tetragon
tetrahedra1452993tetrahedra
tetramerous1353123tetramerous
tetrameters1354623tetrameters
tetrapod1145123tetrapod
tetrarch13104783tetrarch
tetras63017623tetra__s
tetrode839343tetrode_
tetrodes939093tetrodes
tetter64322453tet__ter
titrate72215573titrate_
titrated92611683titrated
titrates82314663titrates
titrator858543titrator
tracer84820233__tracer
trader75218763__trader
tramel84113713__tramel
tramper113812163__tramper
trimer85717153__trimer
vitamer1235473vit_amer

Search took 9 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.406440125.6
2DLD Change Limit146162917.86018595.7
3Display Results91910.0303033.3
 (SQL Overall)178691918.29621539.4
 
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.