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

85 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
screeches169565(None) 
screeched17114341screeched
screecher16144481screecher
screechers17143681screechers
breeches15258672_breeches
creches14313092_cr_eches
creeshes1336952_creeshes
scratches1647322scratches
screech1435222screech__
screechier1742982screechier
screechiest1842742screechiest
screechy1842772screech_y
scrooches1645702scrooches
scrunches1635402scrunches
speeches1537412s_peeches
stretches1438292stretches
beeches143413883__beeches
beseeches1643953beseeches
breaches153714123_breaches
breeched16337383_breeched
caleches15269943_caleches
clenches152910953_clenches
cranches153114543_cranches
cratches153012543_cratches
creche13310763_cr_eche_
creepies1239613_creepies
creeses93914623_cree_ses
creeshed1435693_creeshed
crotches153411303_crotches
crouches153711293_crouches
crunches153711353_crunches
crutches15359593_crutches
drenches14309803_drenches
fleeches16287083_fleeches
frenches163311633_frenches
leeches123911933__leeches
preaches153214893_preaches
reaches123423203__reaches
reechoes1338413__reechoes
retches123318513__retches
sciences1238773scienc_es
scoleces1237083scolec_es
scooches15188413sc_ooches
scootches1635003scootches
scorches15189153sc_orches
scotches15179473sc_otches
scraiched1744203scraiched
scraichs1543993scraich_s
scratched1735393scratched
scratcher1635443scratcher
scratchers1744293scratchers
screeching1843643screeching
screeded1235643scree_ded
screeds106210293scree__ds
screened1137413scree_ned
screener1037573scree_ner
screeners1136733screeners
screens95212183scree__ns
screes85023973scr_e__es
scrieves13387613scrie_ves
scrooched1763843scrooched
scrootches1743323scrootches
scrunched1744033scrunched
scrunchies1744353scrunchies
sculches15176273sc_ulches
scultches1664293scultches
scutches15168883sc_utches
secrecies1346913secr_ecies
seethes103613743s__eethes
seiches12513813s__eiches
sketches1746823s_ketches
skreeghed1841693skreeghed
skreeghs16212103skreegh_s
sneeshes1136513s_neeshes
soroches1338803sor_oches
squelches2343363squelches
stenches132110293s_tenches
stretched1546213stretched
stretcher1446293stretcher
stretchers1545173stretchers
trenches133512603_trenches
unbreeches1742233unbreeches
upreaches1654633upreaches
wrenches163210233_wrenches
wretches16257283_wretches

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 Limit148641857.29620372.9
3Display Results85850.0332575.8
 (SQL Overall)178691857.74923059.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.