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 “screech” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
screech143522(None) 
screechy1842771screechy
breech13348262_breech
creesh11328332_creesh
scraich1436762scraich
scratch1446012scratch
scree720031712scree__
screeched17114342screeched
screecher16144482screecher
screeches1695652screeches
screed95718932scree_d
screeds106210292screeds
screen85216022scree_n
screens95212182screens
screes85023972scree_s
scrooch1444962scrooch
scrunch1444032scrunch
skreegh15182642skreegh
speech1347562s_peech
stretch1236412stretch
beech124315503__beech
beseech1453873beseech
breach134213723_breach
clench133910053_clench
cranch133613533_cranch
cratch134110793_cratch
creche13310763_cr_eche
creed85727393_cree_d
creeds94714773_creeds
creek114917393_cree_k
creeks124812923_creeks
creel75121483_cree_l
creels84416943_creels
creep95218103_cree_p
creeps104213623_creeps
creepy13418803_creepy
creese84014333_creese
crotch133410083_crotch
crouch133910203_crouch
crunch13349503_crunch
crutch13408243_crutch
dreich12377723_dreich
drench12369593_drench
fleech14367343_fleech
french143511213_french
leech104913213__leech
preach133613923_preach
reach105123883__reach
reecho11318653__reecho
reechy14367823__reechy
retch104818303__retch
samech13277033s_amech
saree55044663saree__
sarees65329943saree_s
science1138793science
scooch13228123sc_ooch
scootch1434463scootch
scorch13198093sc_orch
scotch13207523sc_otch
scraichs1543993scraichs
scraigh1335673scraigh
scratchy1843653scratchy
screak125311063scr_eak
screaks13469363screaks
screaky16436223screaky
scream104814253scr_eam
screams114810623screams
screechers17143683screechers
screechier1742983screechier
screeching1843643screeching
screeded1235643screeded
screened1137413screened
screener1037573screener
screw109318543scr_e_w
screwed135710663screwed
screwer124410073screwer
screwers13358063screwers
screws115513893scr_ews
screwup1442973screwup
screwy14659463scr_ewy
scried95817313scrie_d
scries85226823scrie_s
scrieve12448333scrieve
scrootch1542813scrootch
scrunchy1852383scrunchy
sculch13226213sc_ulch
scultch1483543scultch
scutch13247083sc_utch
secrecy1444743secr_ecy
sheesh1237813s_heesh
sheuch14267043s_heuch
siree55238813siree__
sirees64624583siree_s
sketch1535363s_ketch
skreeghs16212103skreeghs
skreigh15243703skreigh
sneesh945893s_neesh
spree74830863spree__
sprees85620643spree_s
squelch2152953squelch
stench114111163s_tench
streek104111413stree_k
streeks11378713streeks
streel64214023stree_l
streels73811343streels
street64125773stree_t
streets73312613streets
stretchy1644083stretchy
trench114211613_trench
unbreech1542233unbreech
upreach1444693upreach
wrench14439353_wrench
wretch14326533_wretch

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271137.00319138.5
3Display Results1131130.0303766.7
 (SQL Overall)1786911137.43924020.8
 
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.