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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
rectifying194637(None) 
acetifying1944452acetifying
beatifying1945732beatifying
certifying1945312certifying
fructifying2352372fructifying
prettifying2044002prettifying
ratifying1656822r_atifying
recertifying2183232recertifying
recodifying2144262recodifying
reedifying1845242reedifying
reifying1539382re__ifying
renotifying1844182renotifying
reunifying1745162reunifying
testifying1745402testifying
aerifying1636493ae_rifying
beautifying2043413beautifying
brutifying1943413brutifying
citifying1845383_citifying
crucifying2143513cruc_ifying
decertifying2292793decertifying
deifying1637633de__ifying
densifying1844813densifying
edifying1636083_e_difying
electrifying2153443electrifying
fortifying2045153fortifying
frenchifying2751733frenchifying
gentrifying1943813gentrifying
gratifying1874213gratifying
identifying1943493identifying
jellifying2443883jellifying
justifying2444053justifying
metrifying1945683metrifying
micrifying2144813micrifying
mortifying1944923mortifying
mystifying2243943mystifying
notifying1645623_notifying
objectifying3051693objectifying
pacifying2045503pac_ifying
pectizing2348013pecti_zing
petrifying1945823petrifying
preachifying2652343preachifying
prenotifying2153053prenotifying
ramifying1855603r_amifying
rarifying1646313r_arifying
recarrying1643653recarrying
receipting1546753receipting
receiving1538993recei_ving
reciting113118073rec_i_ting
reclining121112283recli_ning
recoiling121412413recoi_ling
recoining121313803recoi_ning
recopying1737113rec_opying
rectified1539243rectif_ied
rectifier1457733rectif_ier
rectifies14310813rectif_ies
rectify1536453rectify___
redefying1736093re_defying
refortifying2252793refortifying
rejustifying2652373rejustifying
remodifying2143853remodifying
repacifying2243543repacifying
repurifying2043933repurifying
resifting133512093re_sifting
resinifying1844353resinifying
restaffing1744193restaffing
restudying1543423restudying
restuffing1743163restuffing
retestifying1993413retestifying
retieing92913713re_ti_eing
retiling93319483re_ti_ling
retiming113014193re_ti_ming
retinting102215253re_tinting
retiring92717413re_ti_ring
retitling1039773re_titling
retrying122410453re_t_rying
retying113213833re_t__ying
reverifying2143853reverifying
revivifying2452853revivifying
russifying1743923russifying
sanctifying2043283sanctifying
sectioning1346293sectioning
specifying2144683spec_ifying
tackifying2343803tackifying
terrifying1745163terrifying
verbifying2244353verbifying
verifying1936413ve_rifying
versifying2045033versifying

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.423422437.4
2DLD Change Limit140603876.07623140.7
3Display Results87870.0461891.3
 (SQL Overall)178691876.54527301.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.