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

143 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
screaky1643622(None) 
creaky154911551_creaky
screak125311061screak_
screaks13469361screaks
streaky14447811streaky
creak115418432_creak_
creaks124315962_creaks
creamy134811362_creamy
creasy114612302_creasy
croaky15528482_croaky
freaky16439232_freaky
screaked15246982screaked
scream104814252screa_m
screams114810622screams
screwy14659462scre_wy
sneaky13427842s_neaky
squeaky2343082squeaky
streak104613622streak_
streaks114411272streaks
streamy12509482streamy
acreage1037843acreage
already1144263already
beaky146118023__beaky
braky145015813_br_aky
bready124511183_bready
break115319403_break_
breaks124816423_breaks
caky136222443_c__aky
cheeky18448613_cheeky
cracky175010223_cracky
crake114823523_cr_ake
cranky153910633_cranky
crazy195511223_cr_azy
creaked143413233_creaked
creakily1735393_creakily
cream95721353_crea_m
creams104715253_creams
crease85519573_crease
create85126383_create
creek114917393_creek_
creeks124812923_creeks
creepy13418803_creepy
crepey135110933_crepey
crepy124812703_cre_py
cressy11439113_cressy
croak115216633_croak_
croaks125812983_croaks
dreamy12509993_dreamy
dreary104611673_dreary
drecky16486333_drecky
freak125115243_freak_
freaks134713063_freaks
greasy10419463_greasy
leaky125217723__leaky
ocrea73311823ocrea__
ocreae83310273ocrea_e
ocreate93711743ocreate
peaky145718153__peaky
phreak1536153phreak_
phreaks1634543phreaks
ready94821503__ready
reeky125416263__reeky
sacredly1444473sacredly
sarky125521783sar__ky
scaly104718723sc__aly
scarey115016983scare__y
scary105222593sc__ary
scrag85916173scr_a_g
scraggy14304583scraggy
scrags95713803scr_ags
scram910621623scr_a_m
scrams105216623scr_ams
scrap97120403scr_a_p
scrape105917573scr_ape
scrappy16234473scrappy
scraps106017243scr_aps
scrawl11208093scr_awl
scrawly15197193scrawly
scrawny15213943scrawny
screaking16228243screaking
screamed13277603screamed
screamer12267883screamer
scree720031713scre__e
screech1435223screech
screechy1842773screechy
screed95718933scre_ed
screeds106210293screeds
screen85216023scre_en
screens95212183screens
screes85023973scre_es
screw109318543scre__w
screwed135710663screwed
screwer124410073screwer
screws115513893scre_ws
screwup1442973screwup
scrimpy16486133scrimpy
scroggy14243843scroggy
scrubby1642803scrubby
scruffy1842643scruffy
scry96017763scr___y
seamy105921273s__eamy
secrecy1444743secre_cy
secretary1444203secretary
secretly1345183secretly
shaky154616843s__haky
shrieky17364803shrieky
sleazy18267393s_leazy
sleeky13398963s_leeky
smeary114110803s_meary
snaky125113913s__naky
sneak96016173s_neak_
sneaks104312493s_neaks
sorely94618013sore_ly
speak114618673s_peak_
speaks125114583s_peaks
spray106720063spr_a_y
spread9312533sprea_d
spreads1039763spreads
squeak1935253squeak_
squeaks2034523squeaks
steady103510203s_teady
steak95219803s_teak_
steaks104415853s_teaks
steamy115112373s_teamy
strake104017393str_ake
strawy1210312823str_awy
stray88525573str_a_y
streaked13228453streaked
streaker12229483streaker
streakily1643673streakily
stream84717293strea_m
streams94713373streams
streek104111413streek_
streeks11378713streeks
surely93816463sure_ly
surety93515013sure_ty
sweaty123710053s_weaty
thready14435903thready
treaty94414353_treaty
tweaky1634023_tweaky
unready11215943unready
wreak125513273_wreak_
wreaks134711113_wreaks

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.470380193.6
2DLD Change Limit1340271436.89019452.4
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.40624127.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.