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

115 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
rarefier113535(None) 
rarefied1245911rarefied
rarefiers1244021rarefiers
rarefies1138991rarefies
rarified1239052rarified
rarifies11311932rarifies
ratifier1139672ratifier
reefier102912552r_eefier
aerier64823153_a_erier
argufier1242113argufier
arrester839253arrester
artier63419733_ar_tier
artsier768943_artsier
atelier7311623_atelier
balefire1344663balefire
barefit1249723barefi_t
barkier133814483bar_kier
barmier114313043bar_mier
barnier93213673bar_nier
barrier94017733bar_rier
basifier1337313basifier
beefier12329093_beefier
brevier1237763_brevier
careener1039323careener
career85822243care__er
careerer1038583careerer
carefree1346343carefree
caregiver1542713caregiver
caresser1038803caresser
carrier93619583car_rier
casefied1445943casefied
casefies1339213casefies
clarifier1446123clarifier
crepier1139743_crepier
daffier1457833da_ffier
darklier1335013darklier
defier105118653__defier
draffier1574323dra_ffier
earlier72612743ear_lier
earthier1137443earthier
farrier103514893far_rier
gaselier946963gaselier
gasifier1236273gasifier
gratifier1345823gratifier
hardier114721543har_dier
harrier104417753har_rier
lardier83518343lar_dier
larkier113711523lar_kier
marblier1256343marblier
marlier92614773mar_lier
marrier93817523mar_rier
marshier1337593marshier
pacifier1557503pacifier
parrier93717653par_rier
partier93520713par_tier
prefer113813203_pref_er
prefire124012813_prefire
premier113515633_premier
purifier1338573purifier
putrefier1443123putrefier
racier85120973ra__cier
racketier15165413racketier
raffler13339223ra_ffler
rafter94517583ra__fter
raggedier1242523raggedier
rainier71614263ra_inier
rallier73816273ra_llier
ramified1438043ramified
ramifies13310503ramifies
rammier112811023ra_mmier
randier83618473ra_ndier
rangier83714353ra_ngier
rapier84019993ra__pier
rarebit948423rarebi_t
rarebits1045223rarebits
rarefy12296343raref__y
rarefying1654693rarefying
rarer54731703rar___er
rareripe1045113rareripe
rareripes1165353rareripes
rarities8316333rarities
raspier93110643ra_spier
ratified12310503ratified
ratifiers1236453ratifiers
ratifies11313513ratifies
rattier74015593ra_ttier
raveler104212463rave_ler
raveller11339263raveller
ravener104110733rave_ner
redefied1368223redefied
redefies12710163redefies
reedier83815303r_eedier
reefer93314363r_eef_er
reekier113111123r_eekier
refer84822143__ref_er
refiner105316913__refiner
refire95419473__refire
reifier103414523r_eifier
relier65826183__relier
rereview1443913rereview
sarkier113413313sar_kier
scarifier1446653scarifier
screwier1346433screwier
surefire1145213surefire
surfier102613543sur_fier
tardier859719993tar_dier
tarrier74323173tar_rier
tarsier74119253tar_sier
tartier74123263tar_tier
turfier10249793tur_fier
varier94619353var__ier
verifier14159203verifier
warier93722893war__ier
wartier103413913war_tier
waterier11312083waterier

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 Limit1461621156.62622058.9
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.09525185.5
 
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.