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

64 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
ferreous114603(None) 
ferrous1049791ferr_ous
ferrels10248622ferre_ls
ferrets103111392ferre_ts
feverous1446512feverous
aeneous739893ae_neous
ceraceous1346353ceraceous
cereus85215523ce_re_us
cernuous1055013cernuous
cerous85821203ce_r_ous
cirrous93111063cirr_ous
citreous1056853citreous
corneous10310033corneous
cupreous1255603cupreous
erroneous944003_erroneous
errors63311313_err_ors
farrows13259783farr_ows
fearers104815273feare_rs
feres86038183fe_re__s
ferments13311473ferments
fermions1336203fermions
ferocious1445193ferocious
ferrates113013423ferrates
ferrel92810203ferre__l
ferreled1234843ferreled
ferret93021173ferre__t
ferreted1236333ferreted
ferreter1136543ferreter
ferreters1246253ferreters
ferrety13287013ferre_ty
ferries103521083ferr_ies
ferriferous17112633ferriferous
ferrites112312833ferrites
ferrules1136163ferrules
ferrum1147453ferr__um
ferrums1265983ferr_ums
fervors1336233fe_rvors
fervour1343103fe_rvour
fervours1453053fe_rvours
fibrous1237593fibr_ous
freres94716173frere__s
furious103110633f_urious
furrows13327793furr_ows
generous939773generous
gorgeous1046293gorgeous
jerreeds1653273jerreeds
leprous938843lepr_ous
nacreous1045763nacreous
nervous1037143ne_rvous
ochreous1343773ochreous
pereons92815003pe_reons
perilous10310693perilous
perrons93115483perr_ons
pervious1337543pervious
petrous92714423petr_ous
sericeous1146343sericeous
serious73616283se_rious
serous65023563se_r_ous
terreens8246533terreens
terrenes82212603terrenes
terrets72913583terre_ts
terrors73112213terr_ors
verrucous1442953verrucous
vitreous1145843vitreous

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.420425454.8
2DLD Change Limit146162646.70321805.5
3Display Results64640.0302133.3
 (SQL Overall)178691647.15324981.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.