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

166 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
rectify153645(None) 
acetify1545002acetify
beatify1536592beatify
certify1546242certify
fructify1942352fructify
prettify1644342prettify
ratify122610042r_atify
recertify1743642recertify
recodify1743942recodify
recti73619622recti__
rectory123512732rectory
reedify1465762reedify
reify114814972re__ify
renotify1454832renotify
reunify1344452reunify
testify13246942testify
aerify122810113ae_rify
beautify1643183beautify
brutify1543883brutify
cecity1398153cec_ity
citify1437443_citify
crucify1744063cruc_ify
decertify1843463decertify
deify124112763de__ify
densify1435293densify
destiny113111463destiny
edify12308563_e_dify
electrify1744673electrify
entity9312053_entity
erectile1039513erectile
erecting112415063erecting
erection102115513erection
erective13311833erective
erectly1257483erect_ly
fortify1636523fortify
frenchify2342583frenchify
gentrify1544683gentrify
gratify1436113gratify
hectic132311523hecti_c
hecticly1843003hecticly
heftily1635763heftily
identify1544133identify
jellify2054543jellify
justify2034663justify
lectin82515013lecti_n
lectins92515003lectins
lection92614863lection
meatily12311093meatily
metrify1535623metrify
micrify1744693micrify
mortify1536223mortify
mystify1843563mystify
nectary1246223nectary
notify1236943_notify
objectify2651993objectify
orectic1138823orecti_c
orective1339353orective
pacify1667473pac_ify
pectic122913873pecti_c
pectin102615533pecti_n
pectins112315233pectins
pectize20259913pectize
petrify1536573petrify
pettily1238173pettily
preachify2243053preachify
prenotify1744283prenotify
prettily1337283prettily
racily11715173rac_ily
ramify14268753r_amify
rarify123210063r_arify
reacting113317893reacting
reaction10612603reaction
reactive13310473reactive
readily11711403readily
reality10313573reality
recarry1245063recarry
receipt1159253receipt
receive1239733receive
recency1438633recency
recipe103414893rec_ipe
recit75235103rec_i_t
recital9412173recital
recite83625113rec_ite
recited104319103recited
reciter94117263reciter
recites93524583recites
reciting113118073reciting
recits83621353rec_its
recking144319923recking
recline94020493recline
recoil84016723recoi_l
recoils93814873recoils
recoin84320293recoi_n
recoins94019243recoins
recopy1339043rec_opy
recta74220263rect__a
rectal84418143rect_al
rectally1339713rectally
rectified1539253rectified
rectifier1457733rectifier
rectifies14310813rectifies
rectifying1946373rectifying
recto74520803rect__o
rector84019753rect_or
rectors93520523rectors
rectos85718783rect_os
rectrix1645363rectrix
rectum103411283rect_um
rectums11338523rectums
rectus83314633rect_us
redefy13388763re_defy
reedily1179613reedily
reefy114217703re__efy
refortify1842833refortify
reif76937653re__if_
reifs84819093re__ifs
rejustify2242083rejustify
remodify1743953remodify
rentier73618223rentier
renting84026853renting
repacify1843483repacify
reptile93914083reptile
repurify1643803repurify
resift94017723re_sift
resinify1445053resinify
resiny94617363re_siny
restaff1339013restaff
resting85031183resting
restive10315933restive
restudy1144763restudy
restuff1346953restuff
retestify1543753retestify
retia55326113re_ti_a
retial64724993re_tial
retiary1038333re_tiary
retie55735303re_ti_e
retied75924983re_tied
reties65436193re_ties
retile65929673re_tile
retime85321803re_time
retina65023383re_tina
retine66237333re_tine
retint65633443re_tint
retire64927013re_tire
retry84718083re_t_ry
retting83425883retting
reverify1744813reverify
revivify2042923revivify
ruction93611613ruction
russify1334063russify
rustily103112993rustily
ruttily10338613ruttily
sanctify1644493sanctify
sectary1238273sectary
sectile9311973sectile
section92515663section
specify1764993spec_ify
tackify1934493tackify
techily1537123techily
tectite9310583tectite
terrify1336353terrify
testily102910803testily
verbify1834993verbify
verify153110163ve_rify
versify1636333versify
zestily19167563zestily

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271666.70319995.1
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.15624970.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.