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

127 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
regranting123832(None) 
regrafting1545991regrafting
regrating111316211regra_ting
granting103514522__granting
recanting122414822re_canting
recrating121318792recra_ting
redrafting1545962redrafting
refracting1638732refracting
refronting1437272refronting
regrading121210202regra_ding
regreeting1237342regreeting
regretting1237782regretting
regrinding1335702regrinding
replanting1338522replanting
reprinting131510582reprinting
rerenting102617662re_renting
retracting13311932retracting
aerating92821003ae_ra_ting
begroaning14114113begroan_ing
berating113220763be_ra_ting
decanting132510633de_canting
degrading13137373degra_ding
deranging1238063de_ranging
derating103222283de_ra_ting
deratting1139513de_ratting
descanting1446923descanting
detracting1438713detracting
eglantine1044973_eglantine
engrafting1544183engrafting
grafting13319623__grafting
grating93923183__gra_ting
grunting10269583__grunting
ingrafting1544893ingrafting
legating102313113leg_a_ting
levanting1345523le_vanting
migrating13910533migra_ting
negating102012833neg_a_ting
prefranking2143313prefranking
preplanting1645933preplanting
preprinting1647413preprinting
ranting84025413___ranting
reacting113317893re__acting
readapting1445153readapting
rearranging1343783rearranging
rebaiting12311643re_baiting
rebating112418343re_ba_ting
rebranching1943383rebranching
recaning111416693re_can_ing
recasting122414233re_casting
rechanging1746043rechanging
recharting1637213recharting
recoating121317463recoa_ting
recounting1339193recounting
recreating131214583recreating
recruiting1347903recruiting
redacting13612303re_dacting
redating102620173re_da_ting
redbaiting1446263redbaiting
redrawing1437213redra_wing
reearning1039053reearn_ing
reenacting1357353reenacting
reerecting1339973reerecting
reflating132514713refla_ting
refraining1437263refraining
reframing1538623refra_ming
regaining112411083reg_aining
regaling10315363reg_a_ling
regarding12149153reg_arding
regauging1235543reg_auging
regearing112211413regea_ring
regelating1239953regelating
regimenting1544663regimenting
reglazing2046553regla_zing
regrant8317323regrant___
regranted1137703regrant_ed
regrants9310013regrant__s
regreening1246033regreening
regressing1248143regressing
regrooming1464163regrooming
regrooving1553503regrooving
regrouping1443693regrouping
regrowing1436673regr_owing
regulating12310063regulating
rehanging1437563re_hanging
reheating132314913rehea_ting
relanding112110923re_landing
relating92725443re_la_ting
relenting102716773re_lenting
reloaning10710483reloan_ing
remanding132211143re_manding
remanning12229033re_manning
remating112322413re_ma_ting
remigrating1547593remigra_ting
reminting122315103re_minting
remounting1346673remounting
renting84026853re___nting
reorienting1246353reorienting
repainting13128973repainting
repasting122312843re_pasting
repeating122618983repea_ting
repenting122316553re_penting
replanning1345313replanning
replating122217403repla_ting
reracking1639313re_racking
reraising10313773re_raising
rerouting10311873re_routing
rerunning1036523re_running
reseating102421533resea_ting
resenting102619293re_senting
resinating11313733resinating
reslating102516993resla_ting
resonating11311263resonating
restarting11310663restarting
restating102319413resta_ting
retasting102513413re_tasting
retinting102215253re_tinting
retracing12313293retra_cing
retracking1738163retracking
retraining11310243retraining
retreating111414773retreating
retroacting1447283retroacting
rewrapping1843343rewrapping
rewriting13310413rewr_iting
segmenting1445003segmenting
serrating10513203serra_ting
tenanting1036213te_nanting
warranting1444743warranting

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit1406031276.26622439.0
3Display Results1271270.0632015.9
 (SQL Overall)1786911276.73526531.7
 
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.