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

153 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
rejoice1628745(None) 
rejoiced18296921rejoiced
rejoicer17315341rejoicer
rejoices17287661rejoices
revoice12319181revoice
devoice13347342devoice
rejoicers18324242rejoicers
rejoin134012242rejoi_n
rejoined16318592rejoined
rejoins143111382rejoins
reprice113212832reprice
revoiced14317872revoiced
revoices13278992revoices
choice132010523_choice
crevice1436153cre_vice
deforce13267243deforce
deice84320033de__ice
device124512163de_vice
devoiced15276063devoiced
devoices14307413devoices
entice81316863_entice
etoile6312263_etoile
genoise839423genoise
heroic113516923heroic_
heroics122912003heroics
heroine103517483heroine
heroize193210963heroize
invoice12136243invoice
juice14311323__juice
prejudice2143343prejudice
prentice121012353prentice
preprice1488873preprice
preslice1258623preslice
realise73021813realise
realize162717083realize
rearmice1255213rearmice
reboil83814683reboi_l
reboiled11349393reboiled
reboils94111723reboils
rebore86625653rebo_re
recce9514563re__cce
receive1239733receive
recipe103414893re_cipe
recite83625113re_cite
recline94020493recline
recock145112723reco_ck
recode93618713reco_de
recoil84016723recoi_l
recoiled113613213recoiled
recoiler103210493recoiler
recoils93814873recoils
recoin84320293recoi_n
recoined113614423recoined
recoins94019243recoins
recoupe11109933recoupe
rediae74221993re_diae
redline84218833redline
redock134311543redo_ck
redoing93516733redoing
redone74820053redo_ne
redrive112410563redrive
reduce9713253re_duce
reface113616353re_face
refence12312233refence
refile95122373re_file
refine95225693re_fine
refire95419473re_fire
reforge11259033reforge
regime95313943re_gime
regive104814323re_give
regorge9257833regorge
rehire95415863re_hire
rehouse10311773rehouse
reive85522943re__ive
reject154116283rej_ect
rejig133810123rej_i_g
rejigs14368093rej_igs
rejoicing19136943rejoicing
rejoinder1743713rejoinder
rejudge1634023rejudge
relace83122153re_lace
relic74623363re_lic_
relics84517903re_lics
relict83623903re_lict
reline65434353re_line
relive95120783re_live
relock124713523relo_ck
remise84221953re_mise
remorse9311713remorse
remote84222603remo_te
remove116115573remo_ve
renounce1047403renounce
reoil55321183re_oi_l
reoiled84316853re_oiled
reoils64516873re_oils
repine85627813re_pine
replace113214283replace
replica1137943replica
repose84121413repo_se
repriced132610543repriced
reprices122913353reprices
reprise92715043reprise
reptile93914083reptile
require16148653require
requite162012483requite
reraise7316313reraise
reremice1246023reremice
rerise64325633re_rise
rerose63320843rero_se
reroute7313963reroute
reseize1639553reseize
reshine102816943reshine
reside74224933re_side
resile64627673re_sile
resite64128453re_site
resize154117723re_size
resole64624183reso_le
resolve103910983resolve
resource1046313resource
respace11310913respace
respire9411543respire
respite9513033respite
resplice1237253resplice
restive10315933restive
reticle94112623re_ticle
retie55735303re_ti_e
retile65929673re_tile
retime85321803re_time
retine66237333re_tine
retire64927013re_tire
retore67630773reto_re
retouch1235853retouch
retrace91417343retrace
reunite7312713reunite
revile94921613re_vile
revise94019743re_vise
revive124914823re_vive
revoke135216243revo_ke
revolve13328373revolve
revote94917453revo_te
rewire95421413re_wire
rewoke1339521223rewo_ke
rewore938030163rewo_re
rewove126420083rewo_ve
rewrite10311143rewrite
rexine134719443re_xine
rezone153814783rezo_ne
rice64942913r___ice
service1239083service
unvoice12126153unvoice
veloce11310133velo_ce
verjuice2042573verjuice
voice104915323__voice

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271536.89019452.4
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.34224338.2
 
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.