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

99 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
rarefied124591(None) 
rarefier1135351rarefier
rarefies1138991rarefies
rarified1239051rarified
casefied1445942casefied
ramified1438042ramified
rarefiers1244022rarefiers
rarifies11311932rarifies
ratified12310502ratified
redefied1368222redefied
aeried74221863_a_eried
aerified121310133aerified
argufied1342323argufied
arrested939153arrested
barefaced1743693barefaced
barefit1249723barefi_t
barfed125416383bar_f_ed
basified1437823basified
careened1139193careened
careered1139493careered
carefree1346343carefree
caressed1139163caressed
caried94528693car__ied
carnified1547293carnified
carried103717153car_ried
casefies1339213casefies
clarified1546973clarified
defied115016383__defied
draperied1344983draperied
gasified1336533gasified
gratified1446253gratified
harried113815533har_ried
married104715303mar_ried
nazified2144993nazified
pacified1638363pacified
parented11912213parented
parodied1238333parodied
parried103615723par_ried
parslied1137823parslied
partied103516553par_tied
prefiled143310573_prefiled
prefired144310753_prefired
prefixed21357703_prefixed
purified1438743purified
putrefied1543673putrefied
racemed1237013race_med
racemized2344363racemized
raffled14429083ra_ffled
rafted104714703ra__fted
rallied83514083ra_llied
ramifies13310503ramifies
rapeseed1144463rapeseed
rarebit948423rarebi_t
rarebits1045223rarebits
rared65738323rar___ed
rarefy12296343raref__y
rarefying1654693rarefying
rareripe1045113rareripe
rareripes1165353rareripes
rarities8316333rarities
ratifier1139673ratifier
ratifies11313513ratifies
raveled114113633rave_led
ravelled12419783ravelled
ravened115012283rave_ned
razeed163710013raze__ed
redefies12710163redefies
redefined1445593redefined
redenied10511283redenied
reefed103816583r_eef_ed
reefier102912553r_eefier
refed93921923__ref_ed
refeed104717623__refeed
reffed134712513__reffed
refiled114318653__refiled
refind104717073__refind
refined114720003__refined
refired115116993__refired
refixed183611153__refixed
refried113513873__refried
reified112913783r_eified
relied74926233__relied
remedied1237953remedied
reremind1147513reremind
rerented92516163rerented
rereview1443913rereview
retied75924983__retied
safetied1244663safetied
salified12310363salified
scarified1547293scarified
tariffed1533723tariffed
tarried83914133tar_ried
tepefied1444573tepefied
torrefied13143053torrefied
traceried1247143traceried
tumefied1443353tumefied
unrefined1345463unrefined
varied104817863var__ied
verified151510393verified

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 Filter1786911461620.423422437.4
2DLD Change Limit146162996.81021462.8
3Display Results99990.0501980.0
 (SQL Overall)178691997.28324535.4
 
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.