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

95 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
rejoicer1731534(None) 
rejoice16287451rejoice_
rejoiced18296921rejoiced
rejoicers18324241rejoicers
rejoices17287661rejoices
recoiler103210492recoiler
rejoinder1743712rejoinder
rejoined16318592rejoined
revoice12319182revoice_
revoiced14317872revoiced
revoices13278992revoices
choicer14197893_choicer
deforcer14246903deforcer
deicer94114413de__icer
devoice13347343devoice_
devoiced15276063devoiced
devoices14307413devoices
eloiner7149183_eloiner
enjoiner15225653enjoiner
enticer91510423_enticer
joiner134114133__joiner
juicer1536283__juicer
readier83117423readi_er
realiser82512563realiser
realizer172412113realizer
reboiled11349393reboiled
receiver1337413receiver
reciter94117263re_citer
recliner103211913recliner
recoiled113613213recoiled
recoilers11318153recoilers
recoined113614423recoined
reconfer1337673reconfer
recorder11249633recorder
recover124312623reco_ver
redliner93510473redliner
reducer1059003re_ducer
reedier83815303reedi_er
reefier102912553reefi_er
reekier113111123reeki_er
refiner105316913re_finer
reformer13217953reformer
regainer9249353regainer
reifier103414523reifi_er
reiver95318293re__iver
rejecter17258943rejecter
rejigger1743183rejigger
rejoicing19136943rejoicing
rejoin134012243rejoi__n
rejoinders1843123rejoinders
rejoins143111383rejoi_ns
relier65826183re_li_er
reloader937913reloader
remoter94815973remo_ter
remover124612273remo_ver
renouncer1145843renouncer
rentier73618223renti_er
reoccur1143353re_occur
reoffer1335013re_offer
reoiled84316853re_oiled
reorder8239483re_order
repairer1036783repairer
repiner94816903re_piner
replacer12279743replacer
replier94214973repli_er
reporter10411423reporter
reposer93715333repo_ser
repower12329883repo_wer
reprice113212833reprice_
repriced132610543repriced
reprices122913353reprices
requirer17156113requirer
requiter17168643requiter
reroller8258753reroller
resider84615803re_sider
resolder9259233resolder
resolver11339793resolver
resorter8312183resorter
retailer82911573retailer
retainer82913813retainer
retirer74715013re_tirer
retorter8410733retorter
retoucher1444543retoucher
retracer101411883retracer
reuniter838323reuniter
reviler104314973re_viler
reviser104114663re_viser
reviver134411373re_viver
revoker14419193revo_ker
revolter11279363revolter
revolver14287713revolver
rewriter1137923rewriter
ricer74726613r___icer
servicer1335263servicer
voicer113910543__voicer

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.1731032896.0
2DLD Change Limit146162957.78318779.6
3Display Results95950.0303166.7
 (SQL Overall)178691957.98622375.5
 
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.