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

112 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
rectified153924(None) 
rectifier1457731rectifier
rectifies14310811rectifies
acetified1545892acetified
beatified1577862beatified
certified1548412certified
fructified1942752fructified
prettified1644942prettified
ratified12310502r_atified
recertified1754332recertified
recodified1765532recodified
rectifiers1545172rectifiers
reedified1446502reedified
reified112913782re__ified
renotified1455812renotified
reunified1346592reunified
testified1397842testified
acetifier1444863acetifier
acetifies1447133acetifies
aerified121310133ae_rified
beatifies1459283beatifies
beautified1654223beautified
brutified1544773brutified
certifier1447353certifier
certifies14310323certifies
citified1438253_citified
crucified1744683cruc_ified
decertified1853923decertified
deified123112413de__ified
densified1446713densified
edified12339713_e_dified
electrified1754603electrified
fortified1646503fortified
frenchified2352463frenchified
fructifies1843223fructifies
gentrified1545673gentrified
gratified1446253gratified
identified1545053identified
jellified2044813jellified
justified2045043justified
metrified1547853metrified
micrified17126793micrified
mortified1547383mortified
mystified1845083mystified
nectaried1245443nectaried
notified1238363_notified
objectified2652873objectified
pacified1638363pac_ified
pectized22257593pecti_zed
petrified1548333petrified
preachified2273093preachified
prenotified1753983prenotified
prettifier1543973prettifier
prettifies1545693prettifies
ramified1438043r_amified
rarified1239053r_arified
ratifier1139673r_atifier
ratifies11313513r_atifies
recarried1244983recarried
receipted1445333receipted
received1437983recei_ved
recertifies1644703recertifies
recited104319103rec_i_ted
reclined113613603recli_ned
recodifies16106323recodifies
recoiled113613213recoi_led
recoined113614423recoi_ned
reconfined1645683reconfined
recopied1339843rec_opied
rectify1536453rectif__y
rectifying1946373rectifying
rectitude1244773rectitude
rectories11314643rectories
redefied1368223re_defied
reedifies1347323reedifies
refortified1853443refortified
reifier103414523re__ifier
reifies104218283re__ifies
rejustified2253033rejustified
remodified17115263remodified
renotifies1356893renotifies
repacified1844893repacified
repurified1645163repurified
resifted12310153re_sifted
resinified1445763resinified
restaffed1653753restaffed
restudied11104853restudied
restuffed1663333restuffed
retestified1554283retestified
retied75924983re_t__ied
retiled84420513re_ti_led
retimed104714653re_ti_med
retinted94414363re_tinted
retinued95210823re_tinued
retired84620143re_ti_red
retitled9339553re_titled
retried84419153re_t_ried
reunifies1247583reunifies
reutilized2047023reutilized
reverified1745123reverified
revivified2043833revivified
russified1344733russified
sanctified1644293sanctified
sectioned1246523sectioned
specified1746253spec_ified
tackified1944713tackified
terrified13147573terrified
testifier12116893testifier
testifies12139263testifies
verbified18146013verbified
verified151510393ve_rified
versified16147593versified

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.423422437.4
2DLD Change Limit1486411127.43619989.4
3Display Results1121120.0631777.8
 (SQL Overall)1786911127.92222556.3
 
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.