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

163 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
rejoicing1913694(None) 
rejoicings20141841rejoicings
rejoining17149221rejoining
revoicing15117711revoicing
devoicing16145222devoicing
reboiling12149822reboiling
recoiling121412412recoiling
recoining121313802recoining
rejoicingly2451662rejoicingly
reoiling93217212re_oiling
repricing14310472repricing
adjoining1844033adjoining
cojoining1945753cojoining
deforcing1636063deforcing
deicing11312193de__icing
eloining9310443_eloining
enjoining1745053enjoining
enticing11311803_enticing
heroizing2248493heroizing
invoicing1545333invoicing
joining153011483__joining
juicing1736883__juicing
preboiling1546403preboiling
prejudicing2452193prejudicing
prenticing1547883prenticing
prepricing1746733prepricing
preslicing1546363preslicing
realising10313173realising
realizing19313813realizing
rebaiting12311643rebaiting
rebodying1635003rebodying
rebooking16146393rebooking
rebooting12139023rebooting
reboring11312783rebo_ring
receiving1538993receiving
reciting113118073re_citing
reclining121112283reclining
recoaling121312453recoaling
recoating121317463recoating
recocking18138373recocking
recoding122213853reco_ding
recombing1637323recombing
reconning121410793reconning
recooking16148543recooking
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recouping1438363recouping
redlining111210293redlining
redocking17126783redocking
redoing93516733redo__ing
redonning11127643redonning
redriving1437603redriving
reducing12310203re_ducing
reediting11310953reediting
refacing142512813re_facing
refencing15188853refencing
refiling123116533re_filing
refining122416863re_fining
refiring123513923re_firing
refixing19329793re_fixing
refolding1437453refolding
reforging1437663reforging
reforming1538563reforming
regaining112411083regaining
regiving13269713re_giving
regorging1236823regorging
rehiring122911883re_hiring
rehousing1337253rehousing
reining84425323re__ining
reiving113316843re__iving
rejecting192211153rejecting
rejigging1933923rejigging
rejoice16287453rejoic__e
rejoiced18296923rejoic_ed
rejoicer17315343rejoic_er
rejoicers18324243rejoicers
rejoices17287663rejoic_es
rejoin134012243rejo__in_
rejoins143111383rejo__ins
rejudging1933883rejudging
relacing112516043re_lacing
relining93218743re_lining
reliving122713343re_living
reloading1189883reloading
reloaning10710483reloaning
relocking16137683relocking
relooking14167143relooking
remailing122412473remailing
remaining122212793remaining
remising112516453re_mising
remixing182810333re_mixing
remolding1338163remolding
removing1439083remo_ving
renailing102813333renailing
renouncing1345103renouncing
renowning1336083renowning
repairing12310013repairing
repining114116593re_pining
replacing142210163replacing
repolling122110203repolling
reporting12513903reporting
reposing111213803repo_sing
repositing13310493repositing
repotting12511123repotting
repouring12310073repouring
reprising12312553reprising
requiring1937043requiring
requiting1939883requiting
reraising10313773reraising
rerising93017783re_rising
rerolling102210373rerolling
reroofing1336863reroofing
rerouting10311873rerouting
resailing103314253resailing
reseizing19311233reseizing
reshining13310743reshining
residing103015473re_siding
resiling93520173re_siling
resining92919553re_sining
resiting93521123re_siting
resizing182714163re_sizing
resoaking1439373resoaking
resodding1237203resodding
resoling92916303reso_ling
resolving1337743resolving
resorbing1269353resorbing
resorcin1046823resorcin_
resorcins1146983resorcins
resorting10614613resorting
resowing123111523reso_wing
respacing1438893respacing
respiring12159903respiring
respiting121912863respiting
resplicing1546293resplicing
retailing103214733retailing
retaining102114733retaining
retieing92913713re_tieing
retiling93319483re_tiling
retiming113014193re_timing
retiring92717413re_tiring
retooling1039093retooling
retorting10613273retorting
retouching1644693retouching
retracing12313293retracing
reuniting10310693reuniting
reviling122917213re_viling
revising122714403re_vising
reviving152910503re_viving
revoking1637803revo_king
revolting1339633revolting
revolving1635843revolving
revoting12312033revo_ting
rewiring122911223re_wiring
rewording14158543rewording
reworking17136873reworking
rewriting13310413rewriting
rezoning18310453rezo_ning
ricing94822763r___icing
roiling83220453r__oiling
servicing1545343servicing
unvoicing1545083unvoicing
voicing13279083__voicing

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411636.62622433.0
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.12525079.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.