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

92 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
descriers124569(None) 
decriers11299731de_criers
describers1543581describers
descrier1157621descrier_
descries11311921descrie_s
destriers1038141destriers
decreers11277622de_creers
decrier102713552de_crier_
decries103319802de_crie_s
describer1444612describer_
describes1446002describes
descried1248072descrie_d
deserters10129982deserters
deservers13107292deservers
desirers939262desir_ers
destrier9311822destrier_
bescreens1343173bescreens
criers83918583___criers
dearies83526273de_arie_s
debarkers16164553debarkers
debriefs1433533de_briefs
decayers14307963de_cayers
deceivers1535723de_ceivers
deciders123510753de_ciders
deckers144413833de_c_kers
decliners12358613de_cliners
decoders122810413de_coders
decoyers14287713de_coyers
decreer10269123de_creer_
decrees102513123de_cr_ees
decrials1137133de_crials
decried112612853de_crie_d
decuries11312223decurie_s
deferrers13115153deferrers
defiers113913993de__fiers
deforcers15265503deforcers
deformers15266533deformers
dehorners1344743dehorners
deicers103612733deic__ers
deifiers12348993de_ifiers
demergers13146403demergers
demurrers1243713demurrers
dendrimers1442743dendrimers
deniers84515183de__niers
deporters1277793deporters
deprivers1545213de_privers
deriders102411853de__riders
derivers123811363de__rivers
derriere936043de_rriere
derrieres1044813de_rrieres
derries83124623de_rrie_s
desalters1037673desalters
descanters1345013descanters
descenders1445453descenders
describe1346243descri_be
described1544953described
descriptors1652753descriptors
desecraters1444813desecraters
deserter91211603deserter_
deserver12118383deserver_
deserves12109893deserve_s
designers1136003designers
desilvers13306083desilvers
desirer8310783desir_er_
desires81316133desir_e_s
despairers1343103despairers
despairs1144943despai_rs
despisers1245153despisers
despoilers1343533despoilers
destroyers1443643destroyers
detergers11147183detergers
deterrers10116593deterrers
dewormers15255193dewormers
disarmers1246943disarmers
discarders1445043discarders
discerners1345703discerners
discovers1538153discovers
disorders1146963disorders
dossiers9318043dos_siers
driers74516733d___riers
escapers12337413_escapers
inscribers1442643inscribers
prescribers1793153prescribers
rescreens1144863rescreens
rescripts1374573rescripts
rescuers1037363resc_uers
reservers12138103reservers
resorters939693resorters
scribers12307963__scribers
scries85226823__scrie_s
terriers84210823te_rriers
vestries11314053vestrie_s

Search took 7 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.423422437.4
2DLD Change Limit148641926.39023261.5
3Display Results92920.0462000.0
 (SQL Overall)178691926.85926052.0
 
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.