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 “rerise” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
rerise6432563(None) 
cerise84822041cerise
remise84221951remise
reprise92715041reprise
reraise7316311reraise
rerisen73613641rerisen
rerises73525881rerises
rerose63320841rerose
revise94019741revise
aerie54634602aeri_e
aeries64737782aeries
arise56436432_arise
berime105317332berime
betise85616272betise
cerises94722252cerises
cerite84724872cerite
ceruse83914522ceruse
demise94618322demise
deride84420032deride
derive103817042derive
devise104215752devise
eerie55228532eeri_e
erase54925492_erase
erose55727272_erose
feriae95618602feriae
ferine96422582ferine
frise85322452_frise
merises93421422merises
peise75825772pe_ise
peris75537072peris_
perish114619062perish
perse75429522per_se
peruse84016842peruse
precise113518172precise
premise113818552premise
prerinse1038632prerinse
previse123713792previse
prise74632612_prise
raise54828052r_aise
realise73021812realise
recipe103414892recipe
recite83625112recite
recuse85519162recuse
rediae74221992rediae
redries83721712redries
redrive112410562redrive
refile95122372refile
refine95225692refine
refire95419472refire
refries104419732refries
refuse94817512refuse
regime95313942regime
regive104814322regive
rehire95415862rehire
reis45343232re_is_
reive85522942re_ive
relies65036422relies
reline65434352reline
relish93916952relish
relist64628412relist
relive95120782relive
remised103516842remised
remises93423482remises
remiss84216352remiss
repine85627812repine
repose84121412repose
reprice113212832reprice
reprised112012202reprised
reprises102615462reprises
reraised9312352reraised
reraises8415642reraises
rerig64018482reri_g
rerigs74014792rerigs
reside74224932reside
resile64627672resile
resist64524532resist
resite64128452resite
resize154117722resize
retie55735302reti_e
reties65436192reties
retile65929672retile
retime85321802retime
retine66237332retine
retire64927012retire
retries74129072retries
retuse66617222retuse
reuse56025362re_use
revile94921612revile
revised113815482revised
reviser104114662reviser
revises104220532revises
revive124914822revive
rewire95421412rewire
rewrite10311142rewrite
rexine134719442rexine
rise45945232__rise
seise54727852se_ise
series64540972series
serine65432672serine
terse55026822ter_se
uprise82313692uprise
verism113214262verism
verist93823892verist
verite94323442verite
verse84723582ver_se

Search took 4 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 Filter178691825510.356501941.0
2DLD Change Limit825511052.76629844.9
3Display Results1051050.0333181.8
 (SQL Overall)1786911053.15556637.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.