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

400 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
scream10481424(None) 
cream95721341_cream
scram910621611scr_am
screak125311051screak
screams114810611screams
stream84717281stream
bream95121812_bream
cram85635492_cr_am
creak115418432_creak
creams104715252_creams
creamy134811362_creamy
dream85120392_dream
ocrea73311822ocrea_
ocreae83310272ocreae
ream65841612__ream
scam85932352sc__am
schema1388372schema
scrag85916172scr_ag
scrams105216622scr_ams
scrap97120402scr_ap
screaks13469352screaks
screaky16436212screaky
screamed13277592screamed
screamer12267872screamer
scree720031702scre_e
screed95718922screed
screen85216012screen
screes85023962screes
screw109318532scre_w
screws115513882screws
screwy14659452screwy
scrim95419722scr_im
scrum95418192scr_um
seam66645972s__eam
spread9312532spread
steam76322922s_team
streak104613622streak
streams94713372streams
streamy12509482streamy
abeam9316533_abeam
acre67330773acre__
acreage1037833acreage
acred87126353acre_d
acres76327763acre_s
agleam9158623agleam
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
arrear6310253arrear
ashram1139053ashr_am
beam86939233__beam
boreal84817213boreal
boreas85421733boreas
bread85523113_bread
break115319403_break
breams104815043_breams
bureau8712523bureau
cam78058983_c__am
cereal8315833cereal
cham115532313_c_ham
cheap126915943_cheap
cheat105732453_cheat
clam86332293_c_lam
clean75420413_clean
clear76219053_clear
cleat76335063_cleat
craal74117753_craal
crab85727673_cr_ab
crag75625303_cr_ag
cramp115120693_cr_amp
crams96229153_cr_ams
crap85731843_cr_ap
craw97725263_cr_aw
creaks124315963_creaks
creaky154911553_creaky
creamed123913713_creamed
creamer113714083_creamer
crease85519573_crease
creasy114612303_creasy
create85126373_create
cred76530883_cre_d
credal9311673_credal
credo84815563_credo
creds85418773_creds
creed85727393_creed
creek114917393_creek
creel75121483_creel
creep95218103_creep
creme94319323_creme
crepe95520723_crepe
crept95125893_crept
crepy124812703_crepy
cress75022833_cress
crest74632693_crest
crew96122673_cre_w
crews105917493_crews
croak115216633_croak
diram84419473dir_am
dirham12378273dirham
dram75832003_dr_am
dread74419023_dread
dreams94513983_dreams
dreamt94615713_dreamt
dreamy12509993_dreamy
drear65016903_drear
eczema1973073eczema
escheat12410403escheat
estreat7314813estreat
ferbam1339003ferbam
firearm1237193firearm
fleam106017283_fleam
foram105124933for_am
forearm1238693forearm
freak125115243_freak
gleam86916733_gleam
gram77034583_gr_am
great66034243_great
hareem114312063hareem
harem104924453hare_m
hereat93527413hereat
ihram10310183ihr_am
inseam8329993inseam
irreal657823irreal
joram145816983jor_am
loreal63814313loreal
marram10313883marram
ocean71212963oc_ean
ochrea11316643ochrea_
ochreae12295083ochreae
ocreate93711743ocreate
onstream1045103onstream
oread64619603_oread
outscream1343113outscream
perea75026443perea_
phreak1536153phreak
praam94815613_praam
pram85733493_pr_am
preamp1238993_preamp
prearm104512343_prearm
ram56867273__r_am
read55942533__read
real45750293__real
realm75621623__realm
reams75729623__reams
reap65934743__reap
rear45644553__rear
rearm75923563__rearm
redream10107913redream
rem56150043__re_m
reread71715433reread
reteam83214533reteam
roam67132413__roam
sachem134012223sache_m
sacra74516993sacr_a_
sacral83414413sacr_al
sacred94917103sacre_d
sacrum103910143sacr_um
salaam8711013salaam
saran53730303sar_an
sarcasm1136693sarcasm
sardar73013173sardar
saree55044663sare_e
sarees65329943sarees
sarsar63011843sarsar
satem76021453sate_m
scab85926713sc__ab
scad75725763sc__ad
scag76626893sc__ag
scalar83612433scalar
scamp115717313sc__amp
scams94423973sc__ams
scan65530453sc__an
scar66434203sc__ar
scarab10310063scarab
scare75334463scare__
scared95227293scare_d
scarer84524603scare_r
scarers94618503scarers
scares85033003scare_s
scarey115016983scare_y
scat65848373sc__at
scena74815783sc_ena
scenas84114703scenas
scend85516293sc_end
scene77220573sc_ene
scent75831623sc_ent
schav1338313sc_hav
schemas1468163schemas
scheme1379633scheme
schism1338173schism
schmear1484043schmear
schwa13426843schwa_
schwas14396983schwas
sclera838883sclera
sclerae937933sclerae
scleral937863scleral
scleras948223scleras
score75526733score__
scored94621133score_d
scorepad1363383scorepad
scorer84818253score_r
scorers94115313scorers
scores84725923score_s
scoria8513483scoria_
scoriae9310893scoriae
scrags95713803scrags
scrape105917573scrape
scraps106017243scraps
scrawl11208083scrawl
screaked15246973screaked
screamers13236253screamers
screaming14217823screaming
screech1435213screech
screeds106210283screeds
screens95212173screens
screwed135710653screwed
screwer124410063screwer
screwup1442963screwup
scribal1137963scribal
scribe104613533scribe
scried95817303scried
scries85226823scries
scrieve12448333scrieve
scrimp125110583scrimp
scrims104615933scrims
scrip96619193scr_ip
scrips105316033scrips
script105717903script
scrive115414943scrive
scrod85115063scr_od
scrods94111603scrods
scroll8310163scroll
scroop10299773scroop
scrota8310183scrota
scrotal938483scrotal
scrotum1145103scrotum
scrub94914203scr_ub
scrubs104210313scrubs
scruff1437963scruff
scrums104614253scrums
scry96017763scr__y
scuba94211593scuba_
scubas103710223scubas
scum85924523sc__um
scuta75815753scuta_
scutum1036363scutum
sea36161293s__ea_
seal45654373s__eal
seams75731663s__eams
seamy105921273s__eamy
sear47353843s__ear
seas45755273s__eas
seat47575563s__eat
secrecy1444743secrecy
secret8325063secre_t
secrete9311073secrete
secrets9311773secrets
seem65438563s__eem
sera46141393ser_a_
serac75925203ser_ac
serai56830163ser_ai
seral56336383ser_al
serdab937833serdab
sere46153473sere__
sered65737293sere_d
serein63318463serein
serene63522353serene
serer55935503sere_r
seres55448893sere_s
serest64831613serest
serial64625853serial
seriema938403seriema
serum75223473ser_um
serval93913413serval
sham96436353s__ham
shazam2046603shazam
shea76031573s_hea_
sheaf115424123s_heaf
sheal84927703s_heal
shear85424833s_hear
sheas86331793s_heas
shmear1176933shmear
shred98125613shre_d
shreds105613053shreds
shrew119720163shre_w
shrewd136810773shrewd
shrews129313913shrews
sidearm1035963sidearm
sirdar7269103sirdar
sire46150413sire__
sired66134283sire_d
siree55238813sire_e
sirees64624583sirees
siren54525823sire_n
sirens65318153sirens
sires55945373sire_s
sirra54416323sirra_
sirrah9379753sirrah
sirras63814863sirras
skean94415623s_kean
skelm114211283s_kelm
slam67737973s__lam
smear74416393s_mear
sneak96016173s_neak
sneap75514823s_neap
sora45746913sor_a_
soras55041013sor_as
sore47059533sore__
sored66141783sore_d
sorel56231443sore_l
sorels63921163sorels
sorely94618003sorely
sorer56236573sore_r
sores55454283sore_s
sorest65027993sorest
sorta57125413sorta_
spam85930043s__pam
speak114618673s_peak
spean74620513s_pean
spear75821063s_pear
sperm93216013s_perm
spirea84015633spirea_
spireas94412513spireas
spirem104214163spire_m
sprag86418693spr_ag
sprat76635973spr_at
spray106720063spr_ay
spreads1039763spreads
spree74830863spre_e
sprees85620643sprees
sprent84522383sprent
squeak1935253squeak
squeal1538013squeal
stead65520273s_tead
steak95219803s_teak
steal56125473s_teal
steams84916903s_teams
steamy115112373s_teamy
stem610628243s_te_m
strap77925263str_ap
straw813321293str_aw
stray88525573str_ay
streaks114411273streaks
streaky14447813streaky
streamed11258903streamed
streamer10239503streamer
streek104111413streek
streel64214023streel
street64125773street
strep77120853stre_p
streps86218063streps
stress66616673stress
strew89220653stre_w
strewn96710003strewn
strews96817093strews
stria55723203stria_
striae65422273striae
stroma84313073stroma
strum75619443str_um
struma84313273struma
sucre75019103sucre__
sucres84218893sucre_s
sunbeam1146053sunbeam
sura45740293sur_a_
surah86823253sur_ah
sural55931263sur_al
suras55336323sur_as
sure45447413sure__
surely93816453surely
surer54833093sure_r
surest65026763surest
surety93515003surety
surname937603surname
surra55521343surra_
surras65919533surras
surreal739223surreal
surtax1337843surtax
swam96329983s__wam
swear85316853s_wear
sweat85628403s_weat
syren85216743syre_n
syrens94911993syrens
team66238653__team
thread105011093thread
threap11569663threap
threat95020463threat
tram67034553_tr_am
tread64821703_tread
treat56240353_treat
unread73412673unread
unreal64414453unreal
unseam83313143unseam
uprear8168793uprear
upstream1243553upstream
urea46528053_urea_
ureal56722683_ureal
ureas55826013_ureas
wreak125513273_wreak
ziram163912893zir_am

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164005.53320371.6
3Display Results4004000.1233252.0
 (SQL Overall)1786914005.79630830.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.