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

402 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
screens9521217(None) 
screeds106210281screeds
screen85216011screen_
screes85023961scree_s
bescreens1343172bescreens
boreens9310402boreens
careens94514702careens
creeds94714772_creeds
creeks124812922_creeks
creels84416942_creels
creeps104213622_creeps
greens75716872_greens
moreens939962moreens
preens85020112_preens
rescreens1144862rescreens
sarees65329942saree_s
sarsens7311392sarsens
sateens73710752sateens
scenes84520352sc_enes
screaks13469352screaks
screams114810612screams
scree720031702scree__
screech1435212screech
screed95718922scree_d
screened1137402screened
screener1037562screener
screeners1136722screeners
screwers13358052screwers
screws115513882scr_ews
scries85226822scrie_s
sereins73716112sereins
serenes73222902serenes
sheens95116992s_heens
sirees64624582siree_s
sirens65318152sir_ens
skeens103912912s_keens
spleens937102spleens
sprees85620642spree_s
streeks11378712streeks
streels73811342streels
streets73312612streets
syrens94911992syr_ens
treens65317872_treens
tureens7289872tureens
achenes12313493achenes
ackees124914573ackee_s
acres76327763acr_e_s
acrogens1147243acrogens
acumens1136953acumens
afreets1037013afreets
agrees74915323agree_s
arenes64928393_arenes
arpens84814823_arpens
baleens938473baleens
barrens94414323barrens
bescreen1244303bescreen_
boreen8314313boreen_
breeds94914883_breeds
breeks125310793_breeks
brees75632553_bree_s
brens75823363_br_ens
buckeens1634853buckeens
burdens1039713burdens
careen84119493careen_
careers95218783careers
cees65941593_c_ee_s
ceres75540013_cere_s
cereus85215523_cereus
cheeks154712783_cheeks
cheeps135312913_cheeps
cheers114518913_cheers
cleans85817053_cleans
cleeks125010543_cleeks
codens94821013_codens
copens106119963_copens
covens114919263_covens
cozens176314923_cozens
cranes84330753_cranes
cravens124010113_cravens
creaks124315963_creaks
creams104715253_creams
credent10313973_credent
credos94612843_credos
creds85418773_cr_eds
creed85727393_cree_d
creek114917393_cree_k
creel75121483_cree_l
creep95218103_cree_p
creepy13418803_creepy
creese84014333_creese
creeses93914623_creeses
creesh11328333_creesh
cremes104517993_cremes
crenel84213063_crenel
crenels93711013_crenels
crepes105419343_crepes
crepons1139313_crepons
cress75022833_cr_ess
crests85218703_crests
cretins93216423_cretins
crewels12438483_crewels
crews105917493_cr_ews
criers83918583_criers
cries75438403_crie_s
crones84729243_crones
croons85418423_croons
crowns115615113_crowns
cruets85314953_cruets
darkens12409873darkens
decreers11277623decreers
decrees102513123decree_s
drees65628523_dree_s
dudeens934863dudeens
freers94717303_freers
frees86131393_free_s
gardens93312093gardens
germens1078623germens
gorhens1137183gorhens
greeds84314283_greeds
green65522143_green_
greeny104811453_greeny
grees65132473_gree_s
greets75117423_greets
gyrenes11267523gyrenes
hardens113815023hardens
hareems12428203hareems
harkens144112863harkens
hirees95117293hiree_s
jereeds15326383jereeds
keens95721183__keens
kreeps12427413_kreeps
larees65323113laree_s
lateens74210553lateens
martens93714953martens
moreen8313343moreen_
morgens10310463morgens
mureins9310733mureins
oceans81211003oc_eans
onscreen1044253onscreen_
orceins937743orceins
peens76428193__peens
pereons92815003pereons
poteens92910883poteens
preen75925053_preen_
prees75937173_pree_s
prescreens1443843prescreens
purees84721683puree_s
pyrenes123511223pyrenes
queens15338873_queens
reeds65430903__reeds
reefs85121663__reefs
reeks94124033__reeks
reels55333263__reels
rees45364193__ree_s
regreens9257453regreens
reins56234563__reins
rescreen1046703rescreen_
saddens9309603saddens
sapiens9310173sapiens
sarans64224433sar_ans
saree55044663saree__
sarges75128593sarge_s
sarins63932623sar_ins
sarment9318763sarment
sarments10311963sarments
sarsen6314233sarsen_
sateen63815013sateen_
scalene9310773scalene
scaleni936883scaleni
scalenus1045543scalenus
scalers93817263scalers
scales84529313scale_s
scans74625103sc__ans
scapes105122263scape_s
scarers94618503scarers
scares85033003scare_s
scarfers13408463scarfers
scarless10189053scarless
scarlets10178573scarlets
scarpers124712513scarpers
scarves124511623scarve_s
scena74815783sc__ena
scenas84114703sc_enas
scend85516293sc__end
scends95213003sc_ends
scene77220573sc__ene
scent75831623sc__ent
scents85317023sc_ents
schemas1468163schemas
schemers1576703schemers
schemes1489663schemes
schleps1445483schleps
schmeers1574833schmeers
scions82612233sc_ions
scleras948223scleras
scones84521303scone_s
scopes104719593scope_s
scoreless1155603scoreless
scorers94115313scorers
scores84725923score_s
scorners10228493scorners
scorns85713013sc_orns
scoters93313793scoters
scrags95713803scr_ags
scrams105216623scr_ams
scrapers125510513scrapers
scrapes116217663scrapes
scraps106017243scr_aps
scrawls12177273scrawls
scrawny15213933scrawny
screak125311053scr_eak
screaky16436213screaky
scream104814243scr_eam
screamers13236253screamers
screeches1695643screeches
screechy1842763screechy
screeded1235633screeded
screeding1336313screeding
screenful1452723screenful
screenfuls1552013screenfuls
screening1247183screening
screenings1343263screenings
screw109318533scr_e_w
screwbeans1751303screwbeans
screwed135710653screwed
screwer124410063screwer
screwing14288223screwing
screwup1442963screwup
screwups1542283screwups
screwy14659453scr_ewy
scribers12307953scribers
scribes113713203scribes
scried95817303scrie_d
scrieve12448333scrieve
scrieves13387613scrieves
scrimps13517903scrimps
scrims104615933scr_ims
scrips105316033scr_ips
scripts11509373scripts
scrives124414273scrives
scrods94111603scr_ods
scrolls938063scrolls
scroops11288243scroops
scrubs104210313scr_ubs
scruffs1554173scruffs
scrums104614253scr_ums
scrying1338663scrying
scutes85219193scute_s
secerns987733secerns
secretes10410473secretes
secretins11108463secretins
secrets9311773secr_ets
seeds64330063s__eeds
seeks94724643s__eeks
seels55632823s__eels
seems75525023s__eems
seen46943123s__een_
seeps74828753s__eeps
seeress7311573seeress
seers55136383s__eers
sees45361053s__ee_s
semens84616963s_emens
serein63318463serein_
serene63522353ser_ene
serener73415753serener
serenest82717623serenest
seres55448893ser_e_s
sergers83815633sergers
serges74225963serge_s
series64540973serie_s
serines74229543serines
serins64029673ser_ins
sermons9311783sermons
serpent92916283serpent
serpents102410373serpents
servers103214833servers
serves94423653serve_s
sevens93813663s_evens
shagreens1342633shagreens
sharpens13377813sharpens
shebeens1343333shebeens
sheen85023313s_heen_
sheeny124912193s_heeny
sheers94322403s_heers
sheets93918493s_heets
shereefs1433863shereefs
shortens11288983shortens
shreds105613053shr_eds
shrews129313913shr_ews
shrieks14377673shrieks
shrines104618693shrines
sickees134514213sickee_s
sickens134411483sickens
siemens938413siemens
siree55238813siree__
siren54525823sir_en_
sires55945373sir_e_s
sirrees73410563sirrees
sithens1039383sithens
sixteens1542943sixteens
skeans104512913s_keans
skeen94817403s_keen_
skees95023123s_kee_s
skeets104513253s_keets
skeins103911903s_keins
skenes104616633s_kenes
skreegh15182643skreegh
skreeghs16212103skreeghs
sleekens12274873sleekens
sleeks104512463s_leeks
sleeps83913323s_leeps
sleets64318873s_leets
slovens10316573slovens
smartens10286663smartens
smeeks12428433s_meeks
sneers64016173s_neers
soddens9348413soddens
softens10347623softens
soirees72411643soiree_s
sorbent92915233sorbent
sorbents10279123sorbents
sorbets93012503sorbets
sorels63921163sor_els
soreness8914793soreness
sores55454283sor_e_s
sorners73416863sorners
sorns55028413sor__ns
sorrels7310713sorrels
sorters74221113sorters
sowens93613153s_owens
speans85417143s_peans
speeds94316053s_peeds
speels85116393s_peels
speers85019953s_peers
sphenes123013163sphenes
spleen8310263spleen_
spleeny1234553spleeny
sprains93013593sprains
spreads1039763spreads
spree74830863spree__
sprent84522383spr_ent
sprues84515763sprue_s
squireens1842723squireens
stamens93411483stamens
steeds73814883s_teeds
steeks103613703s_teeks
steels64117983s_teels
steepens10277113steepens
steeps85215193s_teeps
steers63820983s_teers
steins64818343s_teins
stereos74314973stereos
steres63929533stere_s
sterns64616753s_terns
strains74218153strains
streaks114411273streaks
streams94713373streams
streek104111413stree_k
streel64214023stree_l
street64125773stree_t
streps86218063str_eps
stress66616673str_ess
strewers11409053strewers
strewn96710003strewn_
strews96817093str_ews
styrenes11116623styrenes
subteens1037423subteens
succeeds1343693succeeds
sucres84218893sucr_e_s
suddens9308783suddens
sunscreens1252093sunscreens
sureness8912903sureness
surfers103614133surfers
surgeons947033surgeons
surgers83517483surgers
surges73924593surge_s
surreys10489433surreys
surveys13357573surveys
sweeny12358843s_weeny
sweeps114110513s_weeps
sweetens11255433sweetens
sweets94214433s_weets
swevens1334613swevens
sycees11409653sycee_s
syren85216743syr_en_
teens56227483__teens
terreens8246523terreens
threeps12687043threeps
threes97117323three_s
treen55622753_treen_
trees55835763_tree_s
triens65417543_triens
tureen63312723tureen_
tweens9489843_tweens
unreels7258313unreels
wardens113711903wardens
warrens103810893warrens
weens85224053__weens
wheens124610613_wheens
worsens104610263worsens
wrens85016243_wr_ens
yestreens1243533yestreens

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.1561145455.1
2DLD Change Limit1340274027.18618651.1
3Display Results4024020.1562576.9
 (SQL Overall)1786914027.49823831.8
 
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.