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

113 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
retemper123518(None) 
retempers1345021retempers
attemper12103632attemper
remember1434622remember
retempered1543432retempered
revamper1533532revamper
temper103914092__temper
attempers13103503attempers
attempter1342963attempter
beeper103714093be_e_per
creeper11339983cre_e_per
deeper93613503de_e_per
detecter11298733detecter
deterger10147593deterger
deterrer9137013deterrer
detester9239683detester
distemper1444853distemper
keeper123811923ke_e_per
metamer1139613metam_er
peeper103614803pe_e_per
petnaper1243913petnaper
pretender1246663pretender
ratemeter1145283ratemeter
reamer84325213re_am_er
reaper84223143r__eaper
recamier1237603recamier
receiver1337413receiver
recenter102715443recenter
redeemer1145323redeemer
reedier83815303re_edier
reefer93314363re_e_fer
reefier102912553re_efier
reeker103715593re_e_ker
reekier113111123re_ekier
reeler63822573re_e_ler
reenter73217793re_enter
reexpel1643183re_expel
referrer11136053referrer
rehammer1544653rehammer
reheater113413033reheater
rehemmed1634153rehemmed
rejecter17258943rejecter
releaser839503releaser
reletter81311023reletter
remembers1544493remembers
reneger8299493rene_ger
renewer10248693rene_wer
renumber1244243renumber
repaper11310023re_paper
repealer103210703repealer
repeater102615443repeater
repeller103010393repeller
repenter102813863repenter
repumped1534383repumped
reseller83412223reseller
resembler1344583resembler
reserver11119633reserver
resetter81511833resetter
reshaper1336913reshaper
restamped1444433restamped
resumer9410113resum_er
retailer82911573retailer
retainer82913813retainer
retaker113714313ret_aker
retape83917683ret_ape_
retaped103814283ret_aped
retapes93917423ret_apes
retarder9229433retarder
reteamed1138013reteamed
retear63115483rete__ar
retem74221953retem___
retempering1644303retempering
retems83914573retem__s
retene69224273rete_ne_
retenes76324623rete_nes
retested92212533retested
retime85321803retim_e_
retimed104714653retim_ed
retimes95020173retim_es
retirer74715013ret_irer
retorter8410733retorter
retracer101411883retracer
retreater9310203retreater
returner8397983returner
retype11399143ret_ype_
retyped13367303ret_yped
retypes12308623ret_ypes
revamped1634143revamped
revampers1653443revampers
revealer113110073revealer
reveler104116343reve_ler
reveller112912183reveller
revenger1237303revenger
revenuer1136893revenuer
reverer103815833reve_rer
reverser113010483reverser
reverter114812873reverter
romper104213683r__omper
seemer84418043se_em_er
stamper113714403_stamper
steeper93812773_steeper
stemmer113210183_stemmer
stepper113010853_stepper
stomper114111233_stomper
stumper113610093_stumper
tamper104618513__tamper
teemer85515743te_em_er
temped113912893__temped
tempeh13357463__tempeh
tempera11329043__tempera
tempers113513013__tempers
tempter11358213__tempter
weeper114313303we_e_per

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.420425454.8
2DLD Change Limit1461621136.61022112.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.07625253.1
 
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.