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

135 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
regranted113770(None) 
regrafted1435241regrafted
regrated102816331regra_ted
granted94715102__granted
recanted112513512re_canted
recrated112918602recra_ted
redrafted1435142redrafted
refracted1557392refracted
refronted1336052refronted
regraded113410762regra_ded
regrant8317322regrant__
regrants9310012regrant_s
regrate82618662regra_te_
regrates92618402regra_tes
regreeted1136172regreeted
regretted1137232regretted
replanted1248062replanted
reprinted1289042reprinted
rerented92516162re_rented
retracted12410952retracted
aerated85322373ae_ra_ted
begroaned13124053begroan_ed
berated104422133be_ra_ted
cerated103922473ce_ra_ted
decanted122310493de_canted
degraded12288323degra_ded
deranged1137693de_ranged
derated93623503de_ra_ted
deratted1048403de_ratted
descanted1336673descanted
detracted1357793detracted
engrafted1443733engrafted
grafted124110223__grafted
grantee83217133__grantee
granter84117133__granter
grated84523923__gra_ted
grunted9339283__grunted
ingrafted1444423ingrafted
legated92513983leg_a_ted
levanted1245323le_vanted
migrated121110513migra_ted
negated93413233neg_a_ted
prefranked2042773prefranked
preprinted1546543preprinted
ranted74324703___ranted
reacted103015713re__acted
readapted1344803readapted
rearranged1244103rearranged
rebaited11410543re_baited
rebated103619703re_ba_ted
rebranched1843673rebranched
recaned102817203re_can_ed
recanter101913153re_canter
rechanged1646853rechanged
recharted1557563recharted
recoated113416783recoa_ted
recounted1238713recounted
recrate92621663recra_te_
recrates102420373recra_tes
recreated12412533recreated
recruited1236453recruited
redacted12410243re_dacted
redated93120923re_da_ted
redbaited1344713redbaited
reearned948883reearn_ed
reenacted1236853reenacted
reerected1238613reerected
reflated123514293refla_ted
refrained1347223refrained
reframed1437853refra_med
regained102111243reg_ained
regaled93615963reg_a_led
regarded11279803reg_arded
regauged1135143reg_auged
regeared1039433regea_red
regelated1139723regelated
regimented1444913regimented
reglazed1935743regla_zed
regnant8312843regnant__
regrade92612033regra_de_
regrades103212173regra_des
regraft11310153regraft__
regrafts1235303regraft_s
regranting1238323regranting
regreened1145553regreened
regressed1138113regressed
regretter1045973regretter
regrind938983regrin__d
regroomed1344153regroomed
regrooved1443253regrooved
regrouped1343633regrouped
regulated11310463regulated
rehanged1357833re_hanged
reheated122415003rehea_ted
relanded102410463re_landed
related83327573re_la_ted
relented92614943re_lented
reloaned939723reloan_ed
remanded123011323re_manded
remanned11319353re_manned
remated103522473re_ma_ted
remigrated1447493remigra_ted
reminted113615083re_minted
remounted1236283remounted
rented74426593re___nted
reoriented1145343reoriented
repainted1277863repainted
repasted112611533re_pasted
repeated113117443repea_ted
repented112614983re_pented
replanned1235163replanned
replated112817523repla_ted
reprinter1197353reprinter
reracked15169123re_racked
reraised9312353re_raised
rerouted9311143re_routed
reseated93220263resea_ted
resented92716963re_sented
resinated10413283resinated
reslated93517523resla_ted
resonated10510613resonated
restarted10410053restarted
restated93120183resta_ted
retasted92412113re_tasted
retinted94414363re_tinted
retraced111413023retra_ced
retracked1657453retracked
retrained10411313retrained
retreated10312623retreated
retroacted1366133retroacted
rewrapped1763023rewrapped
segmented1345063segmented
serrated92513433serra_ted
tenanted937043te_nanted
warranted1345013warranted

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 Limit1486411356.61022487.3
3Display Results1351350.0632142.9
 (SQL Overall)1786911357.10925135.9
 
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.