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

68 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
heronries124848(None) 
felonries1246202felonries
helotries1269562helotries
henries102718282he__nries
herries104025072her__ries
aeronomies12118323aeronomies
almonries1156923almonries
baronies10315023baron_ies
berries94423553ber__ries
betonies10413063beton_ies
beworries1444843beworries
canonries1148413canonries
cherries131812973cher__ries
coronaries12410223coronaries
cronies9622503_cron_ies
deaconries1345163deaconries
derries83124623der__ries
ebonies9312883_ebon_ies
felonies11310993felon_ies
ferneries1239033ferneries
ferries103521083fer__ries
harlotries1345683harlotries
harmonies141311043harmon_ies
harries103525493har__ries
hedonics1445903hedon_ics
heinies102514543he_in_ies
helleries122611683helleries
henneries1248643henneries
heraldries1443963heraldries
heresies11312693her_esies
heretrices1546293heretrices
heretrixes2044333heretrixes
heritrices1555303heritrices
heritrixes2043743heritrixes
hermitries1546763hermitries
hernias10310773her_n_ias
heroes94923823hero___es
heroicizes2445283heroicizes
heroics122912003hero__ics
heroines112916573hero_ines
heroins103518013hero__ins
heroizes202610983hero_izes
heronry1346043heronr__y
herons94820543heron___s
herried113514453her__ried
herstories1348593herstories
hexones17299143hexon__es
hongies112716473h__ongies
honkies143015143h__onkies
hurries103919653hur__ries
ironies7517423_iron_ies
jerries143817513jer__ries
kerries113317913ker__ries
masonries1146853masonries
memories121214343memo_ries
merceries13410033merceries
mercuries1347253mercuries
peonies93620153pe_on_ies
perjuries1846483perjuries
perries93226603per__ries
serries73925353ser__ries
sherries111812893sher__ries
ternaries9311623ternaries
terries73425613ter__ries
theories11311593the_o_ries
weaponries1543073weaponries
wherries14179023wher__ries
zedoaries1944323zedoaries

Search took 9 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.1731032896.0
2DLD Change Limit148641688.25018017.1
3Display Results68680.0302266.7
 (SQL Overall)178691688.45321139.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.