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

297 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
screaks1346935(None) 
creaks124315961_creaks
screak125311051screak_
screaky16436211screaky
screams114810611screams
streaks114411271streaks
breaks124816422_breaks
creak115418432_creak_
creaky154911552_creaky
creams104715252_creams
creeks124812922_creeks
croaks125812982_croaks
freaks134713062_freaks
phreaks1634542phreaks
scrags95713802scr_ags
scrams105216622scr_ams
scraps106017242scr_aps
screaked15246972screaked
scream104814242screa_m
screeds106210282screeds
screens95212172screens
screes85023962scre_es
screws115513882scre_ws
sneaks104312492s_neaks
speaks125114582s_peaks
spreads1039762spreads
squeaks2034522squeaks
steaks104415852s_teaks
streak104613622streak_
streaky14447812streaky
streams94713372streams
streeks11378712streeks
wreaks134711112_wreaks
acreage1037833acreage
acreages1138363acreages
acres76327763acre__s
araks94820883_ar_aks
areas55935773_area_s
arrears738843arrears
beaks115326623__beaks
bleaks125112433_bleaks
boreas85421733borea_s
breads95419203_breads
break115319403_break_
breams104815043_breams
breeks125310793_breeks
bureaus979283bureaus
cereals9313173cereals
cheaps134613683_cheaps
cheats114519543_cheats
checks174912703_checks
cheeks154712783_cheeks
cleans85817053_cleans
clears84116563_clears
cleats84919313_cleats
cleeks125010543_cleeks
clerks12458843_clerks
cloaks124411263_cloaks
craals84113303_craals
crabs95421393_cr_abs
cracks144817003_cracks
crags85622573_cr_ags
crake114823523_cr_ake
crakes124921813_cr_akes
crams96229153_cr_ams
cranks125015313_cranks
craps95328643_cr_aps
crass76328043_cr_ass
craws105723123_cr_aws
creaked143413233_creaked
cream95721343_crea_m
creamy134811363_creamy
crease85519573_crease
creases94020963_creases
creasy114612303_creasy
create85126373_create
creates95225173_creates
credos94612843_credos
creds85418773_cre_ds
creeds94714773_creeds
creek114917393_creek_
creels84416943_creels
creeps104213623_creeps
cremes104517993_cremes
crepes105419343_crepes
cress75022833_cre_ss
crests85218703_crests
crews105917493_cre_ws
cricks144316053_cricks
croak115216633_croak_
croaky15528483_croaky
crocks145118423_crocks
crooks124914413_crooks
crucks144412583_crucks
debeaks1436103debeaks
dreads84115023_dreads
dreams94513983_dreams
drears74614253_drears
drecks13459203_drecks
dreks105714743_dre_ks
ecofreaks1851043ecofreaks
escheats1346253escheats
estreats839423estreats
freak125115243_freak_
freaky16439233_freaky
greats76318393_greats
leaks95923913__leaks
oceans81211003oc_eans
ocrea73311823ocrea__
ocreae83310273ocrea_e
ocreate93711743ocreate
oreads73915773_oreads
peaks114825623__peaks
phreak1536153phreak_
reads64835273__reads
reals55038653__reals
reams75729623__reams
reaps75626193__reaps
rears54739653__rears
recks115625133__recks
reeks94124033__reeks
rereads81512293rereads
sacrals93311793sacr_als
sameks12409323same_ks
sanjaks1834963sanjaks
sarans64224433sar_ans
sardars83112903sardars
sarees65329943sare_es
sarks96632463sar__ks
sarsars73512143sarsars
scabs94818643sc__abs
scads85419953sc__ads
scags85520973sc__ags
scalars93711903scalars
scams94423973sc__ams
scans74625103sc__ans
scarabs1137293scarabs
scarers94618503scare_rs
scares85033003scare__s
scars75433533sc__ars
scats75930603sc__ats
scenas84114703sc_enas
scends95213003sc_ends
scenes84520353sc_enes
scents85317023sc_ents
schavs1436493sc_havs
schemas1468163schemas
schemes1489663schemes
schmears1584093schmears
schnaps1443703schnaps
schriks16185743schriks
schtiks16184743schtiks
schwas14396983schwa_s
scleras948223scleras
scorepads1473023scorepads
scorers94115313score_rs
scores84725923score__s
scrag85916173scr_a_g
scram910621613scr_a_m
scrap97120403scr_a_p
scrape105917573scr_ape
scrapes116217663scrapes
scrawl11208083scr_awl
scrawls12177273scrawls
screaking16228223screaking
screamed13277593screamed
screamer12267873screamer
screamers13236253screamers
scree720031703scre__e
screech1435213screech
screed95718923scre_ed
screen85216013scre_en
screw109318533scre__w
screwed135710653screwed
screwer124410063screwer
screwers13358053screwers
screwup1442963screwup
screwups1542283screwups
screwy14659453scre_wy
scribes113713203scribes
scries85226823scr_ies
scrieves13387613scrieves
scrimps13517903scrimps
scrims104615933scr_ims
scrips105316033scr_ips
scripts11509373scripts
scrives124414273scrives
scrods94111603scr_ods
scrolls938063scrolls
scroops11288243scroops
scrubs104210313scr_ubs
scruffs1554173scruffs
scrums104614253scr_ums
scubas103710223scuba_s
sculks123610263sc_ulks
seals54839693s__eals
seams75731663s__eams
sears54744913s__ears
seas45755273s__ea_s
seats54844343s__eats
secretes10410473secretes
secrets9311773secre_ts
seeks94724643s__eeks
seracs84418573ser_acs
serais64326133ser_ais
serdabs1035323serdabs
sereins73716113sereins
serenes73222903serenes
seres55448893sere__s
serials73919743serials
servals103410743servals
sheafs124912883s_heafs
sheals94420643s_heals
shears93820903s_hears
sheas86331793s_hea_s
sheiks132510013s_heiks
shmears1277073shmears
shreds105613053shre_ds
shrews129313913shre_ws
shrieks14377673shrieks
shrinks14397913shrinks
sirdars8228213sirdars
sirees64624583sire_es
sirens65318153sire_ns
sires55945373sire__s
sirrahs10377303sirrahs
sirras63814863sirra_s
skeans104512913s_keans
sleeks104512463s_leeks
smears84714433s_mears
smeeks12428433s_meeks
smerks12449713s_merks
sneak96016173s_neak_
sneaky13427843s_neaky
sneaps84510863s_neaps
snecks124410033s_necks
soaks95220293s__oaks
soras55041013sor_a_s
sorels63921163sore_ls
sores55454283sore__s
speak114618673s_peak_
speans85417143s_peans
spears84019473s_pears
specks144312703s_pecks
spireas94412513spirea_s
sprags95715823spr_ags
sprats85819933spr_ats
sprays115913643spr_ays
spread9312533sprea_d
sprees85620643spre_es
squeak1935253squeak_
squeaky2343073squeaky
squeals1636503squeals
steads74116223s_teads
steak95219803s_teak_
steals64020063s_teals
steams84916903s_teams
steeks103613703s_teeks
strake104017393str_ake
strakes114218073str_akes
straps87721783str_aps
strass67117223str_ass
straws98718673str_aws
strays96417933str_ays
streaked13228453streaked
streaker12229473streaker
streakers13218123streakers
stream84717283strea_m
streamy12509483streamy
streek104111413streek_
streels73811343streels
streets73312613streets
streps86218063stre_ps
stress66616673stre_ss
strews96817093stre_ws
stricks134310693stricks
sucres84218893sucre__s
surahs94515543sur_ahs
suras55336323sur_a_s
surpass938283surpass
surras65919533surra_s
swears94114073s_wears
sweats94814613s_weats
syrens94911993syre_ns
teaks94222903__teaks
threads11419953threads
threaps12488643threaps
threats104311673threats
treads74817913_treads
treats64821693_treats
treks96016853_tre_ks
troaks104410593_troaks
tweaks1335963_tweaks
uprears9107493uprears
ureas55826013_urea_s
wreak125513273_wreak_
wrecks15418883_wrecks

Search took 9 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.1561145455.1
2DLD Change Limit1340272977.86017051.8
3Display Results2972970.0933193.5
 (SQL Overall)1786912978.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.