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

101 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
remember143462(None) 
remembers1544491remembers
comember1644162comember
member12258852__member
remembered1743352remembered
rememberer1652622rememberer
renumber1244242renumber
resembler1344582resembler
retemper1235182retemper
cementer1239193cementer
comembers1744223comembers
demerger12127373demerger
dismember1643983dismember
disremember1851993disremember
ember95516803___ember
emeer74815363_eme__er
emender10649843_emender
emmer94314463_em_m_er
gemmier12337383gem_mier
hemmer134112643hem_m_er
members13258603__members
misremember1661993misremember
nonmember1543123nonmember
premerger1444903premerger
prenumber1543163prenumber
rammer103519653ram_m_er
rammier112811023ram_mier
reamer84325213re_am_er
recamier1237603recamier
receiver1337413receiver
recenter102715443recenter
recombed1536713recombed
redeemer1145323redeemer
reedier83815303re_edier
reefer93314363re_e_fer
reefier102912553re_efier
reeker103715593re_e_ker
reekier113111123re_ekier
reeler63822573re_e_ler
reembark1643883re_embark
reenter73217793re_enter
referrer11136053referrer
rehabber1563153rehabber
rehammer1544653rehammer
reheater113413033reheater
rehemmed1634153rehemmed
rejecter17258943rejecter
releaser839503releaser
reletter81311023reletter
remaker133813173rem_aker
remarker14178493remarker
remaster10311473remaster
remedied1237953remedied
remedies11310553remedies
remeet86325473reme__et
remelted11310153remelted
rememberers1751893rememberers
remembering1843683remembering
remended123010393remended
remerge10148923remerge_
remerged12149173remerged
remerges111110203remerges
reminder113110513reminder
remitter102810323remitter
remoter94815973rem_oter
remover124612273rem_over
reneger8299493rene_ger
renewer10248693rene_wer
renumbers1344123renumbers
repealer103210703repealer
repeater102615443repeater
repeller103010393repeller
repenter102813863repenter
reseller83412223reseller
resemble1247313resemble
resembled1445173resembled
resemblers1443413resemblers
resembles1376073resembles
reserver11119633reserver
resetter81511833resetter
resumer9410113resum_er
retempers1345023retempers
revamper1533533revamper
revealer113110073revealer
reveler104116343reve_ler
reveller112912183reveller
revenger1237303revenger
revenuer1136893revenuer
reverbed14269223reverbed
reverer103815833reve_rer
reverser113010483reverser
reverter114812873reverter
rimester1037813rimester
rimmer103516033rim_m_er
rummer104715483rum_m_er
rummier11309563rum_mier
seemer84418043se_em_er
sememe10129983semem_e_
sememes11109203semem_es
semester1038903semester
teemer85515743te_em_er

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.436409841.7
2DLD Change Limit1461621016.69021847.8
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.15624970.8
 
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.