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

50 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
felonries124620(None) 
felonies11310991felon_ies
falconries1543952falconries
helotries1269562helotries
heronries1248482heronries
almonries1156923almonries
belfries1336983bel_fries
betonies10413063beton_ies
beworries1444843beworries
calories102919553calo_ries
canonries1148413canonries
celeries10316313cel_eries
colonies103620013colon_ies
deaconries1345163deaconries
ebonies9312883_ebon_ies
felines104718073felin__es
felinities1349433felinities
fellies104119743fel__lies
felonious1244453felonious
felonry13294843felonr__y
felons93615763felon___s
feodaries1346373feodaries
ferneries1239043ferneries
ferries103521083fe__rries
feudaries1345883feudaries
flaneries1249563f_laneries
floosies113210233f_loosies
floozies20326953f_loozies
floppies1546813f_loppies
florins10311643f_lo_rins
flossies112810123f_lossies
flunkies1536393f_lunkies
flurries11188913f_lurries
fooleries1248743fooleries
fulleries1248723fulleries
glories81915913_glo_ries
helleries122611683helleries
henries102718283he__nries
longies82916553__longies
lories64933043__lo_ries
lorries74518343__lorries
masonries1146853masonries
melodies11310123melo_dies
memories121214353memo_ries
pelorias10410593pelo_rias
peltries10313023pel_tries
peonies93620153pe_on_ies
weaponries1543073weaponries
zealotries1944353zealotries
zedoaries1944323zedoaries

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.420425454.8
2DLD Change Limit148641507.30020361.8
3Display Results50500.0301666.7
 (SQL Overall)178691507.75023056.9
 
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.