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

57 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
devilries134525(None) 
deviltries1444131deviltries
devilkins1742802devilkins
revelries1246922revelries
aviaries1139783_aviaries
breviaries1564003breviaries
cavalries1446363cavalries
dailies84219263d_ail_ies
dairies84217733d_ai_ries
deaneries10310833deaneries
dearies83526273de__aries
debilities13411293debilities
deciares11510633deciar_es
deciles104417723decil__es
decries103319803de__cries
decuries11312223de_curies
defilades14134073defilades
defiles114016843defil__es
deifies113317453de_i_fies
deities82621923de_i_ties
deliveries1446013deliveries
dellies83622213de__llies
demilunes1244473demilunes
demiurges1343863demiurges
depilates12310923depilates
derries83124623de__rries
descries11311923de_scries
desires81316133desi_r_es
devalues1235853deval_ues
developes15155283developes
deviances1566493deviances
deviancies1644593deviancies
deviates12312733devi_ates
devices133212583devi__ces
deviled124112183devil__ed
devilfish1942323devilfish
devilfishes2151993devilfishes
deviling1311812853devil_ing
devilish1546373devil_ish
devilkin1642953devilki_n
devilled1336743devil_led
devilling1436703devilling
devilry1433973devilr__y
devils104412813devil___s
devisees12358283devi_sees
devises114116763devi__ses
devitrifies1852873devitrifies
devitrify1941963devitrify
devolves15286263devol_ves
diaries83321953d__iaries
dillies84122163d__illies
doilies84017363d_oil_ies
jewelries1943033jewelries
levities11310713levi_ties
reveries112518513rev_eries
reviles104421353revil__es
rivalries1245003rivalries

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.1731032896.0
2DLD Change Limit148641577.36020195.8
3Display Results57570.0134384.6
 (SQL Overall)178691577.54623680.2
 
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.